Macro to copy active sheet and rename as date

[tonywatsonhelp]

Hi Everyone,

OK so I want a macro that when I run it it copies the active sheet but removes all the formulas and saves as values,
Then renames the copied Sheet to "Bookings" and todays date. without changing the original sheet
then I want it to Place in Cell D3 "Ordered" and todays date.

please help as i'm stuck

Thanks

Tony

 

[crazydragon84]

have you tried the macro recorder? seems like pretty easy to record and make edits so the date is today's date

Hi Everyone,

OK so I want a macro that when I run it it copies the active sheet but removes all the formulas and saves as values,
Then renames the copied Sheet to "Bookings" and todays date. without changing the original sheet
then I want it to Place in Cell D3 "Ordered" and todays date.

please help as i'm stuck

Thanks

Tony