Auto naming tabs based on cell values

[GregF22]

Hi,

I have a worksheet with dates in cells A3-F3 and the worksheet as 10 tabs.
How can I have Tabs 4-9 be auto named from the dates in A3-F3?

Thank you

[Artik]

Assuming that the A3:F3 range is in the first sheet from the left:

Please Login or Register  to view this content.

Artik

[GregF22]

Hello Again,

I am still trying to get this figured out, as I could not get the suggestion from Artik to work. Maybe it will be easier uploading the sheet so you can see it.
On the "data cell" tab, I only change the date in cell A3 each week and it auto fills the rest of the week for me in Row 3 B-G.
What I would like, is whenever I change the date in cell A3, it will change the 6 tab names on the bottom to reflect the revised dates in A3-G3.
Is this possible? Thank you in advance for taking the time to try and help me

[Artik]

Try it:

Please Login or Register  to view this content.

Attention, the code is sensitive to the language version. In the Polish version, I will get the name "pon._gru04" instead of "Mon_Dec04" for the first changed sheet.

Artik

[Marc L]

According to the attachment whatever the language version a VBA demonstration for starters :

Sub Demo1() 
    For C% = 1 To 6 
        Sheets(C + 3).Name = Sheet1.Evaluate("TEXT(" & Cells(3, C).Address & ",""[$-409]ddd""""_""""mmmdd"")") 
    Next 
End Sub  

► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄

[GregF22]

Big Thank you to Artik & Marc. Your guys were a big help and problem solved !!