Create and rename worksheets as per cell range

[alf40]

Hi All

I have been searching around for some code but have had no luck.

I have attached a sample (very basic) worksheet.

What I would like to achieve:

Enter the start date in cell C5 and end date in C6. Then I would like to run the macro and have 2 worksheets created for each date in the range. One of the worksheets called e.g. 10052013D and the other 10052013N and then the same for the other dates in the range.

Is there any way that I can achieve this?

Thank you for your help!

[dilipandey]

Hi alf40,

Click on the blue button in the attached sheet where I used below vba code:-

Payload Data No Logo.xlsm

Please Login or Register  to view this content.

Regards,
DILIPandey
<click on below * if this helps>

[alf40]

Hey mate

That works really well. Thanks for your help.

How do I modify the macro to add the sheets directly after the 'menu' sheet?

Thanks!

[alf40]

And how do I get it to add sheets but basically copy the sheet labelled 'lead sheet' and rename it?

Thank you so much!

[dilipandey]

Hi alf40,

Post#3 can be looked into.. but post#4 has to be a new thread as it not related with this current thread as current thread title says "create and rename worksheets..... ", so please post a new thread for post#4. Thanks.


Regards,
DILIPandey
<click on below * if this helps>

[alf40]

Hey mate

I still want to create and rename the sheet as per post 1. I just want the new sheet that is being created to be an exact copy of the 'lead sheet'.

[dilipandey]

For your post#3, use below code :-

Please Login or Register  to view this content.

Regards,
DILIPandey
<click on below * if this helps>

[dilipandey]

I still want to create and rename the sheet as per post 1. I just want the new sheet that is being created to be an exact copy of the 'lead sheet'.

Hi Mate, that should come under a thread "Create copies of existing sheet as per cell values"


Regards,
DILIPandey
<click on below * if this helps>