Auto Name Worksheet while referencing diff worksheet

[fourmurphys]

I've found code to allow for auto-naming of a worksheet, but seems to only work while referencing cell contents on same worksheet.

What I'd like to do is auto-name worksheet "A" by referencing a cell on worksheet "B"....

Any ideas?

Thanks very much in advance for any direction!

[GC Excel]

Hi,
Something like this :

Please Login or Register  to view this content.

[fourmurphys]

Thanks GC, but sheet "A" is unknown and would need to be generated automatically. Sheet "B" would be known and unchanging.

Here's what I've had, but again, it references cell on the same worksheet. Thanks!

Please Login or Register  to view this content.

[GC Excel]

I'm not sure I understand what you want to do...
Can you post a sample file ?
From what I understand, when cell F1 is changed on your sheet, you rename all sheets with the value of their cell F1 ??

[Norie]

Sheet 'A' is not unknown, if it's just been created then it's ActiveSheet, or you could have set a reference to it when you created it.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

You can even name it when you create it.

Please Login or Register  to view this content.

[fourmurphys]

Norie... you're right! It's not unknown... duh... because the known name will be changed. Will try this and report back.

[fourmurphys]

Well... I just can't get it... I'm attaching the file, and in a nutshell this is my goal. First, the worksheets will already exist and will need to be renamed.

Using the contents of the SUMMARY tab, cells C4 through D4, I need to rename the 9 worksheets. If I can figure this out will have other applications as well, since changing 9 tabs isn't too bad... Thanks in advance if you have time to review and offer suggestions!

[GC Excel]

Hi,
Maybe something like this :

Note that in your file, you have 9 columns and 7 sheets to rename...

Please Login or Register  to view this content.

[fourmurphys]

GC, sorry, but should I be swapping out a placeholder with an actual name/location? I've tried it and I'm getting a runtime error '1004' related to not being able to rename a sheet to the same name as another sheet? I created a module for the code and ran as macro...

Thanks!

[GC Excel]

You can't have 2 worksheets with the same name, thats correct.
In the file you sent, that was not the case...
What is not clear is how the tabs are named BEFORE you run the macro (and how many there are...)

[fourmurphys]

Wanted to update... I went the lazy route, and just named my tabs 1-12. It's not elegant, but it works.

I do appreciate the help!