Referencing Cells in another worksheet in same workbook
I have 3 spreadsheets in the same workbook. Cells in sheet3 all reference
cells in sheet1. When a row is moved from sheet1 to sheet2, I need for that
row to be removed from sheet3 but instead, it remains and now has a reference
to sheet2. How can I get cells in sheet3 to contain only those on sheet1?
My formulas in sheet3 look like this:
=Sheet1!A5
Thanks in advance...
--
Robert Hill
|