I can create arrays but what about dynamic arrays? E.g. Say I have an employee and an employee ID on one sheet (My employee sheet) and then on another sheet I...

I don't know what happened. I had a spreadsheet with columns A,B,C..... and all of a sudden it's showing up with columns 1,2,3,..... It still has rows...

Can someone help me i need to get the total from the amount column to generate over to the amont paid column, the to columns always are the same amount. this...

In cell B6 i have a date in the format dd-mmm-yyyy, when I use the following formula whilst it gives the correct answer ... when I use the answer in a further...

Hello, I am trying to link several cells in a row, so that when I sort one column, the rest of the row of information stays with the sorted cell. Thank...

I need to conditional format a cell to a colour for the maximum number in a range but I keep getting the maximum number plus one or two other numbers not...

Line and row numbers ......... I took these out some time ago so that my sheet does not display them, how do i get them back in again thanks

I have Office 2003. I figure an example will make things easier. I want B5 to =A5*A1, B6 to =A6*A1, B7 to =A7*A1, and so on. When I try to auto fill I can't...

Question: Is there a way to copy all rows in a worksheet to a master data list at the same time, and have possibly several users saving their worksheet forms...

Is there a way to insert a picture and have the data on the spreadsheet appear through the picture. I would like to insert a picture of an aerial picture and...

How do you show the complete path for a file in Excell" in the Title Bar? e.g. C:\House\budget.xls instead of just budget.xls

I collect data in hyperterminal - every minute one number - I want to put this number with a timestamp into excel - how do I do this ?

I have a date in cell G7 (say 21 Jun 2005), in a seperate text note I want to say " as at the end of May 2005". Where the date in G7 varies and the date in...

CELL A1 has a number CELL B1 is the total (A1). As I add a number in CELL A2 I want CELL B2 to be the running total. Then I add a number to CELL A3 and I want...

As an example. I have a spreadsheet, columns A, B, C, D, E, F, G, H, I, J (with no column names). I need to copy three cells from each row into another...

I HAVE excel 97.Don t know any MVB. I have never used Excel before. , but want to use it to clean up a query that I made in Access. So I exported the...

I am trying to design a macro to work with a database I made in excel. I have a lot of questions since I have never made a macro before. But I'll just start...

I have a spreadsheet that i need to update (created by someone else). Some of the cells contain lists (for example list of 10 items in one cell. Now if I want...

I am building a spread sheet where the first sheet has thousands of names and other details. The names column needs to be automatically fills (along with other...

I am trying to use excel to enter information for each employee in a building company according to where they have worked each day, and how many hours at each...