I have a personal finance sheet that has the pages:
summary <-- main page
to give my cells understandable names.
From the main page (Summary) I have 4 cells:
All 4 cells are defined as:
1) $'PNC Inv'.$B$6
The data from the main page Summary is the only one that doesn't work. I get:
for it. All the other ones give the appropriate numbers. Why can't I get data from the summary page ON the summary pae?