mcrmike < wrote:

On my worksheet (totals hours worked each day for all employes) I have a
macro assigned to a button (update) on the worksheet which copies the
sheet, deletes all data and then updates the dates to the next week.
The problem is, when I click the button and it copies the worksheet it
always uses the original sheet (sheet1) instead of using the new
updated sheet (sheet2,3,ect.) when I run the macro each additional
time. I understand that the macro is referencing sheet1, but I don't
know how to make it reference the active sheet. Help would be greatly
appreciated. Thanks.

Search in your code the references to sheet1 and change it for ActiveSheet.

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.