Adding 1 new tab each week with a week number

[mholton63]

I need macro or VBA that will add a new tab each week with the current week number and clear certain cells . Any Ideas?

Regards, Mark

 

[The_Macrotect]

Hi Mark,

A few questions for you:

1) Should the macro make a copy of the previous sheet?
2) Which cells need to be cleared?
3) When should the macro run? (Every Monday, Every Friday at 2 PM, The first time the workbook is opened any given week, ect...)

Matt

 

[Mholton]

This is a time sheet for my employees. I would like it to save a copy of the current work weeks times and name the tab with "Week 1" etc...and clear the master tab to start filling out for the next week. There certain rows and columns that will not get cleared. I think I can figure that part out. Thanks for the help.

 

[mholton63]

This is a time sheet for my employees. I would like it to save a copy of the current work weeks times and name the tab with "Week 1" etc...and clear the master tab to start filling out for the next week. There certain rows and columns that will not get cleared. I think I can figure that part out. Thanks for the help.