jackosieves
Petroleum
- Feb 5, 2010
- 24
I have a spreadsheet with quite a few tabs, each of which is linked to multiple charts. We add data daily and I wanted to have the charts update dynamically. I am in the process of naming the dynamic ranges and found that in order to do so that the names of my tabs needed to have no spaces, dashes, underscores, etc. I was just wondering if this is the case or if there is a way around this. Some of the tabs would be extremely hard to read and tell apart from others without the dashes and spaces.
An example of one of my ranges is below. I'd like to have the tab named FED 34-35H though instead of FED3435H. Is there a way to do this? Thanks for any help or pointers that you are able to offer me.
=OFFSET(FED3435H!$C$3,1,0,COUNTA(FED3435H!$C:$C)-2,1)
An example of one of my ranges is below. I'd like to have the tab named FED 34-35H though instead of FED3435H. Is there a way to do this? Thanks for any help or pointers that you are able to offer me.
=OFFSET(FED3435H!$C$3,1,0,COUNTA(FED3435H!$C:$C)-2,1)