Copying data from another cell, I think there are macros

S

sami123

I have a source spreadsheet but when I copy data from this sheet t
another the results indicate just zeros not the numbers. The sam
happens when I create a formula to use the numbers on the first sheet
Can i go around this and just link the numbers to my spreadsheet an
then use my formulas. I do not want just to copy the values. Pse am no
conversant with macros
 
D

Dave O

I suspect you're seeing zero values in the second sheet because the
formulas in the first sheet refer to cells that are not present in the
second sheet. Yes, you can link cells between sheets: from sheet 2,
enter = then click over to sheet 1 and click on the relevant value.
 
Top