PDA

View Full Version : macro to save a Worksheet



jarodz22
04-06-2008, 06:08 PM
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
04-22-2008, 10:41 AM
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
Sheets("name of your sheet").Copy Before:=Sheets(1)

Bob Phillips
04-22-2008, 11:17 AM
and



ActiveSheet.Name = Format(Date, "dddd")