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")
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.