copy worksheet for each day of the month

D

David T

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.
 
D

Don Guillett

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 data>filter>autofilter to isolate.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy worksheet with VBA for Each day of month 2
Count the Number of Weekdays by Month 3
Create a shorter list of dates 11
Calculate Holiday 2
make copies of worksheet for each day of month 1
Display number of day of month depending on the year 1
Sum of data where a condition applies 1
Macro or Formula to have a cell match the date on the tab. 4

Top