Spreadsheet Information

Closed
Ben - Apr 20, 2010 at 02:19 PM
rizvisa1
Posts
4479
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 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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