Copying data from second worksheet & copying formula

[RobertD]

I am building a worksheet that requires me to bring data from another worksheet.

I have both worksheets open and to enter the data I am typing = and then switching to the other worksheet and entering on the required cell.

This is bringing the data across correctly however when I attempt to copy the formal down the column to automatically bring the data across I can only ever get the exact formal to copy and not one that adjusts the cell reference.

I don't know idiots relevant but the worksheet I am building is in csv format.

Id appreciate help in how to copy these formulas correctly?

Thanks

 

[Snakehips]

Robert,

Welcome to the board.

When you switch and select the cell you wish to link to it is picking up the 'absolute ' cell reference.

IE with $'s eg $D$5. To remove the $'s, press the F4 key whilst the cell is selected and you can toggle to get D5.

Then your formula will copy down.

Alternatively, you could perhaps select and Copy all of the cells you need to link to in the one sheet then go to the other sheet and do a Paste Special / Paste Link !!!????

Hope that helps.