Hi,
in sheet2 enter a formula like

=sheet1!A1

copy formula

"mikki" wrote:

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.