Auto-generate new sheets with starting and ending date. [Closed]

Report
Posts
1
Registration date
Thursday October 27, 2016
Status
Member
Last seen
October 27, 2016
-
I started using macro in excel and I would like to inquire how to generate sheets by just giving the starting and ending dates. For example, I have the main(first) sheet saved as 'main' and on Column D5 and D6 of this sheet I have the starting and ending dates respectively . For example 1/05/2016 and 31/10/2016.

So I would like to generate 6 other sheets automatically i.e 1 for each month containing the days/dates of each month in columns in each of the sheet.

Can someone help?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!