Spreadsheet Information

Closed
Ben - Apr 20, 2010 at 02:19 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 20, 2010 at 02:37 PM
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 January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 20, 2010 at 02:37 PM
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
0