Create a new worksheet based on the date

[s7yzrs]

Good morning everybody,

I have this worksheet that I need to optimize. I have created a master sheet and I can create a new sheet by using this:

Please Login or Register  to view this content.

This works fine... but... Rows 2 (C:AF or C:AG, depending on the month, should contain the date (Mon, Tue, Wed, etc) while row 3 (C:AF or C:AG, depending on the month, should contain the date (01,02,03, etc).

Also I need to be able to create as many sheets as I need, right now I can only create the one that concerns the current month (this is because I might need to assign next months flights ahead of time, i.e. charters).

Is there a way that this can be achieved?

Thank you for any help/suggestions you can give

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks