×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Dynamic Range name and Tab naming conflicts?

Dynamic Range name and Tab naming conflicts?

Dynamic Range name and Tab naming conflicts?

(OP)
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)  

RE: Dynamic Range name and Tab naming conflicts?

(OP)
One thing I just thought of would be to create tabs with the names that I want and link them to tabs with the no space naming convention.  I could then hide the tabs that have the no space names.  That way I could name my dynamic ranges but still have the nice and clean tab names.  Could there be something else I could do that would be easier?

RE: Dynamic Range name and Tab naming conflicts?

Try single quotes around the tab name:

=OFFSET('FED 34_35H'!$C$3,1,0,COUNTA('FED 34_35H'!$C:$C)-2,1)

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
 

RE: Dynamic Range name and Tab naming conflicts?

Maybe you can give the cell and column a name (named range).   

=====================================
(2B)+(2B)'  ?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources