macro to save a Worksheet

[jarodz22]

I need a macro to copy a worksheet that contains tables and charts and pasted on other workshhet. This copy operation will be made daily and pasted every day in a diferent wooksheets named by the names of the week

thanks in advance for the help

[jazznaura]

hi,

Record a macro while doing it manually.
Right click the tab of the sheet and click on “move or copy”, check “create copy” at the bottom and state were to put it. click ok and stop recording.
then the user only has to name it.
will look like this
[VBA]Sheets("name of your sheet").Copy Before:=Sheets(1)[/VBA]

[Bob Phillips]

and

[vba]

ActiveSheet.Name = Format(Date, "dddd")
[/vba]