I want to create a worksheet with a specific date Oct 2006.
I want to offer the user a choice of dates with a range of 12 months prior adn 12 month after the current date.
When the date is selected a check should be made to ensure the worksheet doesnot already exists.
If not then the sheet is created with the "Month Year" format as the name,
Can this be done.
Any help or outline of VBA code would be appreciated!!
Thanks,
Liam
I want to offer the user a choice of dates with a range of 12 months prior adn 12 month after the current date.
When the date is selected a check should be made to ensure the worksheet doesnot already exists.
If not then the sheet is created with the "Month Year" format as the name,
Can this be done.
Any help or outline of VBA code would be appreciated!!
Thanks,
Liam