Simi
New member
- Joined
- Feb 10, 2012
- Messages
- 190
- Reaction score
- 0
- Points
- 0
- Location
- Utah, USA
- Excel Version(s)
- Version 2002 Build 12527.20194
Can you refer to the name of a worksheet in a formula?
I have a work around this so far by just putting the name of the worksheet in cell A1 then referring to that cell,
but I don't want to have to code that all the time when my sheet names are the value I want.
Also I need help with a sum formula. I want to get a sum of cell A5 to (end of entered data).
Thank you,
Simi
I have a work around this so far by just putting the name of the worksheet in cell A1 then referring to that cell,
but I don't want to have to code that all the time when my sheet names are the value I want.
Also I need help with a sum formula. I want to get a sum of cell A5 to (end of entered data).
Thank you,
Simi