VBA Copy and Rename 2 Worksheets with current date but different shifts.

[Jeff S]

Hello,
Having issues with 1 button macro on a menu worksheet that copies 2 separate worksheets and places a cell value on them.
Example:

It would be executed from Staff Summary Sheet and copy then rename the Working Sheets.
I get it to copy but I somehow mess up with the renaming part.

 

[smozgur]

That did it, now I repeat for Blue and that should fix it. I would never have remembered that. Thanks Joe. I tried so many ways to make this work and remember doing it years ago. Old age I guess. Your a life saver. Thank you!

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.