copy worksheet for each day of the month
Hello-
I have a worksheet that i need to copy for each day of the month and each worksheet needs to be named for the corresponding day, however each saturday, sunday, and monday needs to be on one tab. For example, i have a tab for day 1 for March name "1" which i want to copy for each day. Day 2 will be named "2" and 3 be named "3". On day 8 - 10 (which is Saturday - Monday), i want only only 1 tab named "8-10". Any help is appreciated. thanks. |
copy worksheet for each day of the month
If you need a separate sheet for each day, you must have a lot of entries.
Maybe you would prefer to have it all on one sheet with the dates. You can always use datafilterautofilter to isolate. -- Don Guillett Microsoft MVP Excel SalesAid Software "David T" wrote in message ... Hello- I have a worksheet that i need to copy for each day of the month and each worksheet needs to be named for the corresponding day, however each saturday, sunday, and monday needs to be on one tab. For example, i have a tab for day 1 for March name "1" which i want to copy for each day. Day 2 will be named "2" and 3 be named "3". On day 8 - 10 (which is Saturday - Monday), i want only only 1 tab named "8-10". Any help is appreciated. thanks. |
All times are GMT +1. The time now is 11:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com