From Template Worksheet – Copy, Rename, & End In Ascending Order

[DDM64]

I need assistance with a "loop" or "Do While" routine that will iterate through the following process approx. 1,095 (365 days x 3) times:

1) Copy “Daily Template” worksheet.

2) After copying, Rename Copy to “string” but needs to be sequential name with this naming format:

a) Each sheet represents a Date.

b) Each Date sheet has consists of 3 sheets of the same Date, however, it is a
“string” date with a number at the end. The actual sheet types are: 1-1-1, 1-1-2, 1-1-3; 1-2-1, 1-2-2, 1-2-3; 1-3-1, 1-3-2, 1-3-3, 1-4-1,
1-4-2, 1-4-3, etc.

c) 1-1-3 Definition = 1 represents the month of the year; hypen; 1 represents the day of the year, hyphen, 1 represents Area.

3) As the above alpha-numeric sheets are being copied and renamed, I need to have them populated in the workbook in Ascending Order.

Your assistance with this subroutine, is greatly appreciated. Deanna

[arlu1201]

Do you have a sample file that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[DDM64]

Bump no response - From Template Worksheet – Copy, Rename, & End In Ascending Order

Could someone please assist me.

The details are included in thread and sample file has been attached.

Attached is the requested sample file.Daily Dates.xlsx

[AlphaFrog]

That's a lot of sheets. You may want to first test this on say a two month date range.

Please Login or Register  to view this content.

[DDM64]

Hello AlphaFrog.

My apologies for not replying right away. I have been working on other parts of code for my project all weekend. It worked perfectly of course. You are very cool. Thanks a bunch for your help.