Formulas transferring to other pages in workbooks, but data isn't.
I have a multipage spreadsheet where I want to take data input on page one and transfer it to page two. I selected the cell on page two, put in the equal sign and then went to page one and clicked on the cell. The cell in page two said page1!B4, but not the data in cell B4 on pg. 1. What did I do?
|