mark_98034
New Member
- Joined
- Mar 22, 2009
- Messages
- 2
I am trying to search for a given cell (B2) based off of the name of the sheet?
I have 10 different sheets with various names, but the value I want off of all the sheets is in B2.
When I load the download the data onto the sheets the value is erased. For example. I have a sheet named Sheet1 and want the value in B2. On my master sheet I have tried =Sheet1!B2 but each time I refresh the data on the Sheet1 I get a #REF! error.
Thanks for any help!
Mark
I have 10 different sheets with various names, but the value I want off of all the sheets is in B2.
When I load the download the data onto the sheets the value is erased. For example. I have a sheet named Sheet1 and want the value in B2. On my master sheet I have tried =Sheet1!B2 but each time I refresh the data on the Sheet1 I get a #REF! error.
Thanks for any help!
Mark