Macro needed to name excel tabs based on unique cells within each tab

Hi Ardiko

Try this Code...place the Code in ThisWorkbook Module

Please Login or Register  to view this content.

Hi Ardiko

To insert the Code into your Workbook:

1. Go into VBA ----> Alt + F11
2. Click on ThisWorkbook in the Left Hand Panel
3. Paste the Code in the Right Hand Panel
4. Exit Vba
5. Save the File as a Macro Enabled File (.xlsm)

I've attached your Sample File with the Code embedded.

You're welcome...glad I could help. Thanks for the Rep.

If this resolves your issue please mark your Thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Hi Ardiko

I don't really know what your asking

is there anyway I can refresh all tabs at once

Are you suggesting there's a value in Cell $C$2 in some or all of these 140 sheets and you'd like to update the Sheet Name and the Combined Sheet with that value?

Hi Ardiko

I'm still at a bit of loss as to what you're asking. See if this Code answers your question. Place the Code in a General Module.

You'll need to Comment out or delete the Change Event Code previously provided before running this Code. What the Code does is iterate through the Worksheets. If Cell C2 is not blank the Sheet is renamed to the Value of Cell C2 and SHEET SUMMARY is updated with the Revised Sheet Name.

I have no idea if this is what you're after...

Please Login or Register  to view this content.

Hi Jas,

Thanks for all your help and I greatly appreciate it.
The macro did work and now its bugging again.

All I need to learn is how to run a macro automatically in several spreadsheets at once.
The sheet summary is just a function formula so it will do it by itself.

The new question
If I wanted to make all the columns a certain width and to run that macro on all tabs, how could I do that? The first macro you gave me changed the tab experiment but I would have to run it on each tab for it to work. Whenever I try to this I always get runtime errors.

I made a separate thread about this but no one has answered it as of yet.