Apply macro to all sheets!!!

Hi,

I have a macro setup on a payroll sheet so that when the date is changed the current sheet is wiped. and is replaced with new dates and days. This is so there is never any confusion over times worked and in what month. They always have to be entered from scratch when the month is changed.

I want my macro to update all sheets in the same way so that when i click on a box named january it updates all time sheets to january and deletes all the old data.

Can anybody help?

thanks in advance.

Hello Sirishgreen,

You would need to post your workbook. Since the information is confidential, you would need to create a smaller sanitized version for posting.

Sincerely,
Leith Ross

i forgot to make a copy before i came home so i will post when i get to work tomorrow.

Thanks Leith

Hello Sirishgreen,

Not a problem. I'll look for your post tomorrow.

Sincerely,
Leith Ross

Hey,

There you go thats the workbook, Im trying to do a button for each month on the setup page, the code / macro would have to work for newly added sheets aswell, so when a new employee is added the spreadsheet can still be used.