Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy worksheet with VBA for Each day of month | Excel Discussion (Misc queries) | |||
how to copy formulas across a 1-31 day file and month end total | Excel Discussion (Misc queries) | |||
Sum values, by month, in another worksheet | Excel Worksheet Functions | |||
Create Month Timetable on a worksheet different month each works | Excel Worksheet Functions | |||
How do I copy only the month from a date | Excel Worksheet Functions |