I have to add in a drop down button on each cell with links to other cells in the sheet. The button has to be mounted in the top left corner which overlays the...

I am having a problem with my formula changing all of the sudden. For example, I have columns A1 through A20 A21 is adding columns A1 thru A7 ...

I have several users who are able to access the same workbook from the same location even though the workbook is not set up as a shared workbook. The users do...

Hi I have posted something similar to this before, and got=20 near the answer, but not quite. Any ideas? Sheet 1, called "Unavailability", contains the...

It is a dynamic formula in that sense it starts in H9 and depending on where the first 0 is in C9:C20 it will count numeric values in...

We have an Excel Worksheet that we want to control where the line feed occurs in our cell. Is there something we can insert into the text string to force the...

I am opening a spreadsheet that contains links to external sources. This spreadsheet was created in Excel 97. When I open it, I am prompted to update or...

I created a Pivot Table from a SQL cube. In the Pivot Table, my column dimension contained a hieracrchy :Fiscal Year,Qtr,Month. In the Pivot Table, I chose to...

WHEN I EXPORT MY CONTACTS TO EXCEL, I GET ONLY ONE LAST NAME IN CELL A1 AND NOTHING ELSE. IT ISN'T EVEN ONE OF MY CONTACTS, IT IS JUST MY LAST NAME IN LOWER...

I have two worksheets. the first has 1 column of info that largely follows a trend of the data in the coulumn incrementing by 1 as you go down. the second has...

I would like to have a year range in the header that looks like 2002-2003 but am unable to do it. I am using the following VB macro: Sub...

-----Original Message----- Hi: Can someone please explain to me how to do the following?: I have 2 sheets (Sheet1 & Sheet2) in the same workbook. I...

Can someone please help me with a dynamic formula to add days to a date to be used for projection at an actual present known rate? A1 Start Date: B1 Finish by...

I want to use the today() function in a template and have it convert to the value when I create a new worksheet based on that template. Any suggestions? -HB

All, I have a pivot table where are sum up the values of a column. The pivot table shows the information correctly but shows the rows for which the sum is...

I think this works assuming you dont need to go back to the twenties in your list, try it In A1 02 12 03 23:43 is 37957.98865 so =LEFT(A1,5) is 37957 and

+ Return row number: - Active cell: "=ROW()" - Specific cell: "=ROW(reference)" or "=CELL ("row",refernce)" + Return column number: - Active cell:...

I have a UDF that amongst other things inserts 2 new rows a little way above where a command button sits. After the user has clicked on the button and the...

I have a situation where I need to consolidate several sheets up to one master sheet. Here's the scenario: We have 4 branches for each of the departments to...

Hi: Can someone please explain to me how to do the following?: I have 2 sheets (Sheet1 & Sheet2) in the same workbook. I want cell A1 of sheet1 to always show...