Auto fill

[mikki]

When I have a spreadsheet #1 and would like it to automaticaly update
spreadsheet # 3 in the same workbook, how do I do that. I know that there is
a way but I cannot remember.

 

[Eduardo]

Hi,
in sheet2 enter a formula like

=sheet1!A1

copy formula