Hi Excelforum Experts,
I am currently using an excel macro template to consolidate multiple workbooks into one. However, I always spend much time renaming each worksheet of the workbook (I am now using the output of my excel macro template).
In this regard, I would like to seek help for someone who could help me add additional VBA codes to the existing excel macro template I am currently using. I am attaching the excel macro template I am referring for you to add a function where it will automatically rename each worksheet of a workbook based on cell value. Below are the additional criteria of my desired output:
1.) The additional VBA code should also run after clicking the "Automate" button on my excel macro template (see attached workbook).
2.) Rename each worksheet based on "cell A4" of each worksheet. Cell A4 of each worksheet is Start Date: mm/dd/yyyy, the date may vary per worksheet.
3.) The mm/dd/yyyy should be formatted to m/dd, thus, if cell A4 of Sheet1 is Start Date: 2/09/2017, Sheet1 will be renamed as 2.09. If cell A4 of Sheet2 is Start Date: 2/12/2017, Sheet2 will be renamed as 2.12. And so on.
Let me know should you need clarifications. Thank you!
Warmest regards,
Arnel
Bookmarks