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.