Macro to rename sheets based off cell value

Closed

ExcelMiner - Nov 5, 2015 at 12:00 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 17, 2015 at 11:46 AM

Hello,

I have a workbook that I copy each month with dated sheets I would like to be able to rename each sheet based on the date.

Vba rename sheet based on cell value
Rename computer cmd - Guide
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
Rename lg tv - Guide
Lg tv rename inputs ✓ - Smart TV Forum
Excel macro to create new sheet based on value in cells - Guide

3 responses

Answer 1 / 3

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Nov 10, 2015 at 11:24 AM

Hi ExcelMiner,

Could you give some examples of sheet names?

Is sheet name text and date or only date? Date in which format?

Best regards,
Trowa

ExcelMiner Posts 3 Registration date Wednesday November 11, 2015 Status Member Last seen April 18, 2016
Nov 11, 2015 at 05:14 PM

For data collected on 11/20/2015 the sheet name would be "11-20".

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Nov 12, 2015 at 10:58 AM

You were talking about multiple sheets, but we can't give the same name to all sheets.

How would you like to handle that?

Answer 2 / 3

ExcelMiner
Nov 12, 2015 at 12:40 PM

Sorry I guess I didn't explain it well. Each sheet would be a different date so a different sheet name.

Thank you

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Nov 16, 2015 at 11:09 AM

It's still not clear to me.

Do you have a workbook with multiple sheets like:
11-02
11-12
11-20
11-30
And you want a code that change the 11 into a 12?

OR

Do you have a list with dates and you want to create a sheet for each date in the list?

OR

Something else....

ExcelMiner Posts 3 Registration date Wednesday November 11, 2015 Status Member Last seen April 18, 2016
Nov 16, 2015 at 03:49 PM

the current workbook for November has sheets for 6 work days a week Monday thru Saturday. So the sheets are named 11-02, 11-03, 11-04, 11-05, 11-06, 11-07, 11-09, and so on till 11-28. each sheet is dated in cell A5 in mm/dd/yyyy format. Of course a sheet can't be named in this format so in cell AB4 [=A5] in mm-dd format. I thought after doing that I could use this macro.

Sub RenameTabs()
'Updateby20140624
For x = 1 To Sheets.Count
If Worksheets(x).Range("AB4").Value <> "" Then
Sheets(x).Name = Worksheets(x).Range("AB4").Value
End If
Next
End Sub

However the macro reed it in the original format mm/dd/yyyy. I would like it to read from a cell on the page like I tried to do.

Similar discussions

Code to move rows into another sheet based on certain values

Auto Filter depending on Cell Value

Excel Macro: Rename all Worksheets

copy a row from one worksheet to another, based on criteria

Copy Rows from one sheet to others based on a condition

Code to move rows into another sheet based on certain values

Similar discussions

Subscribe To Our Newsletter!