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
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
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]
and
[vba]
ActiveSheet.Name = Format(Date, "dddd")
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber