Macro to rename sheets based off cell value

Closed
ExcelMiner - Nov 5, 2015 at 12:00 PM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 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.

3 replies

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
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
0
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".
0
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
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?
0