Hi, I have a work book that has 28 sheets in it. I'll be using this as a "template" book for each pay period. Currently the sheets are named: Thursday 1 Days, Thursday 1 graves Friday 1 Days, Friday 1 graves, Saturday 1 days , Saturday 1 graves....etc to Wednesday 2 days and Wednesday 2 graves. On sheet 1 (Thursday 1 days) I have the start of the pay period date in the format mm-dd-yy in Cell A2:L2. The value in cell a2 is linked across sheets by a formula based on the first sheet ='THURSDAY-D 12-12-13'!A2:L2 +13 would be the last sheet so it consecutively dated it based on the first sheet.
I need the vba to Automatically change the sheet tab based on A2:L2 yet leave the day of the week in front of the date: IE The first tab should be Thursday-D 12-12-13, 2nd tab would be Thursday-G 12-12-13, third tab Friday-D 12-13-13, 4th tab Friday-G 12-13-13...etc so that the last tab is Wednesday-G 12-25-13.
So if I go into sheet one and change the date only in A2:L2 it will automatically rename ALL tabs in the workbook based on the consecutive date change leaving the day of week and which shift D or G in front of date.
Hope that makes sense.
I need the vba to Automatically change the sheet tab based on A2:L2 yet leave the day of the week in front of the date: IE The first tab should be Thursday-D 12-12-13, 2nd tab would be Thursday-G 12-12-13, third tab Friday-D 12-13-13, 4th tab Friday-G 12-13-13...etc so that the last tab is Wednesday-G 12-25-13.
So if I go into sheet one and change the date only in A2:L2 it will automatically rename ALL tabs in the workbook based on the consecutive date change leaving the day of week and which shift D or G in front of date.
Hope that makes sense.
