Solved Copying a cell from one sheet to another on excel

June 11, 2013 at 06:56:32
Specs: Windows 7
I have an excel spreadsheet for my home accounts and would like to get a formula that copies from a cell on sheet 1 to a cell in sheet 2. The cell to copy should automatically change when I move down and add a value to the cell immediately below on the next row on sheet 1. I know this can be done as an ex colleague did it for me many years ago - now I have had my laptop stolen and cannot get the formula back.

See More: Copying a cell from one sheet to another on excel

Report •

June 11, 2013 at 10:05:22
I don't know if I completely understand what you're trying to do, but it sounds like you want the value in the cell from sheet1 displayed in a different cell on sheet2.

On sheet2, select the cell you want to see the value from sheet1 in. Type a '=' in the field without the ' ', click on sheet1 then click in the cell you want to display on sheet2 and press 'enter' on your keyboard.

Law of Logical Argument: Anything is possible if you don't know what you're talking about.

Report •

June 12, 2013 at 07:50:52
Sorry if I did not make it clear. If I do what you are saying then each time I make a new entry on sheet one (ie add a value to the cell below the previously copied one on the next row), then this value should show in the same cell as before on sheet 2. For example: I copy whatever value is in cell F7 on sheet one to C3 on sheet two and then when I enter a value in F8 I want this value to show in C3 on sheet two. Thereafter after adding a value, each cell below in column F on sheet one will show in C3 on sheet two.

I hope this is clear!!


Report •

June 12, 2013 at 09:36:57
✔ Best Answer
Using your example of F7, F8, etc., as long as there are no blank cells in Sheet1!F1:F8 nothing in Column F below F8, this formula should work:


The INDIRECT function converts a text string into a cell reference.

The COUNTA function returns the number of cells within a range that contain data.

Therefore, with data in every cell of the range F1:F8, the formula above will evaluate to:




When you add data to F9, the COUNTA function will return 9, etc.


Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

June 13, 2013 at 01:46:37
Forgive my ignorance but can you tell me which of the formulae that you have listed I actually need to put in to the cell on sheet 2. I have tried them all but when I press enter the following appears <body>.


Report •

Ask Question