tezza
Active Member
- Joined
- Sep 10, 2006
- Messages
- 375
- Office Version
- 2016
- 2010
- Platform
- Windows
- Web
Hi all, please put me out of my misery.
When I put =Sheet2!A2 into a call I get the value from Sheet 2 Cell A2 - great!
How do I change the Sheet2 part to Sheet (read the number from another cell say B1) - eg =sheet'B1'!A2 to get the same info as above?
I've tried indirect, brackets, &'s but not getting what I need.
This time I'm using office 365.
The reason behind it is I've put a little =sheet() formula in each sheet so users can simply use the sheet number rather than having to type in the tab name each time, plus it then reads 5 sheets across - twice but that's by-the-by.
Regards
Tezza
When I put =Sheet2!A2 into a call I get the value from Sheet 2 Cell A2 - great!
How do I change the Sheet2 part to Sheet (read the number from another cell say B1) - eg =sheet'B1'!A2 to get the same info as above?
I've tried indirect, brackets, &'s but not getting what I need.
This time I'm using office 365.
The reason behind it is I've put a little =sheet() formula in each sheet so users can simply use the sheet number rather than having to type in the tab name each time, plus it then reads 5 sheets across - twice but that's by-the-by.
Regards
Tezza