Hi,
I've been working on this particular code for quite some time. I have a workbook and I'm wanting to make a copy of an existing worksheet for my users to track their functions each month. The code works great to duplicate my active sheet. However, when i go to key in information on the new worksheet nothing appears. When i click on a previous worksheet the data has updated there. I've tried several methods for copying a worksheet and this continues to happen. Can someone please help. Below is a snapshot of the code i'm running. Any help is greatly appreciated.

Sheets("Master").Copy after:=Sheets("Master")

NewSheetName = ActiveSheet.Name

Sheets(NewSheetName).Activate
Sheets(NewSheetName).Name = MonthName(VBA.Left(mydate, 2), False) & " " & Year(Date)