Tab Formulas in Excell

June 21, 2011 at 06:32:15
Specs: Windows Vista
I'm currently creating a spread sheet that will be distributed to my colleagues. This doc will act as a template. In an effort to make it more user friendly I wanted to create something so that what they write in a certain cell will automatically populate as the tab title. For example in Sheet1 users can list competencies in cells B18-B23. I wanted these competencies to populate as tab titles - since the titles will vary from user to user. So if a user typed Teamwork in cell B18 I would like that to populate as the next tab title. If that user then typed Leadership into B19 I want that to populate as the tab title3...etc.

Is there any formula that I can use so that whatever is written in a cell will automatically appear as one of the tab titles?

See More: Tab Formulas in Excell

Report •

June 21, 2011 at 09:56:19
Do the sheets already exist and you just want to change the sheet names to match or do the sheets need to be created when the data is entered in B18:B23?

BTW...this can't be done with formulas, but it can be done with a macro.

That will mean that all users will need to have their Excel security settings set to allow macros to run or at a minimum know how to change their settings.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

June 22, 2011 at 10:34:52
you can simply select the cell, say "'sheet 1'! b2" and eneter a equal sign and select the other cell. "'sheet 1'! b2" will copy any thing that you put in the other cell. if you are getting wierd numbers or dates, press ctrl 1 and select the number tab and formate the cell, hope that helps

Report •

June 22, 2011 at 16:23:28

Please go back and re-read the OP's post.

He wants to rename the sheet tabs of Sheet2, Sheet3, etc. based on what the users enter into the cells on Sheet1.

You can't rename a sheet with a formula.

Once the OP answers the question I asked in Response #2, I'll offer a suggestion that should work for him.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question