Rename 16 tabs when data in 1 cell of 1 worksheet is changed

**ILoveStMartin** · 10-26-2012, 07:42 AM

Have 17 worksheets, each with descriptions. Have four ending in "week 1", four ending in "week 2", four ending in "week 3" and four ending in "week 4".
When a number is placed in C7 of the 17th worksheet, I need the 1 of the four "week 1" tabs to change to that #, and those tabs that now have "week 2" in them to change to the number in C7 +1, those tabs that now have "week 3" in them to change to the number in C7 +2,to read and those tabs that now have "week 4" in them to change to the number in C7 +3.
Notes, 1; Not using what shows on the tab to identify the tab in other macros, am using the "sheet" name of each of the 17. 2;. Number in C7 may be changed 3 to 5 times so this will not be a 1 run macro.
Thanks

**arlu1201** · 10-26-2012, 07:46 AM

Do you have a sample file that you can upload and we can test on?

**ILoveStMartin** · 10-27-2012, 12:01 AM

Love to upload it - but how does one do that??

**arlu1201** · 10-27-2012, 05:24 AM

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**ILoveStMartin** · 10-28-2012, 06:56 AM

Send This.xlsx File to Rename 16 tabs

**arlu1201** · 10-30-2012, 10:45 AM

I need the 1 of the four "week 1" tabs to change to that #

Any 1 of the 4 sheets can be chosen? Your file shows only 1 sheet. Do you have a sample with all 17?

**ILoveStMartin** · 11-01-2012, 06:31 AM

Master wout macros & logos.xlsmMaster_wo_Macro-logo_shrunk
Got it this time
This file will automatically be saved with the customers name and the weeks the file is covering. All the data in the file naming is entered into the first tab - Job Info. All other tabs now have week 1 or week 2 or week 3 or week 4.
I need the week 1 tabs to read the same as "beginning week" shown in the Job Info tab, and the others notched up accordingly.
Thank you!!!