Spreadsheet Information

Closed
Ben - 20 Apr 2010 à 14:19
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 Apr 2010 à 14:37
I have one Xcel 2003 spreadsheet with 2 almost identical worksheets. How can I make what is entered in worksheet1 "automatically" appear in worksheet 2, please?

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
20 Apr 2010 à 14:37
Let say you want information in cell A1 on sheet1 to appear of cell p1 on sheet2 then in sheet2 on cell p1, write

='sheet1'!a1