| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy worksheet from previous month and rename to current month
I have a spreadsheet to track time spent on various projects. I would like
to create a macro (tied to a button) that users can click to copy the previous months worksheet and rename it to the current month and year. I.E. I may have a worksheet named "DECEMBER 2005" with current projects filled in. I would like to copy that sheet and have it renamed to "JANUARY 2006" if I run the macro in Jan of 2006. Similarly, in FEB of 2006 I would like to copy the JANUARY 2006 sheet and rename to FEBRUARY 2006, and so on. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3-Color Scale Vlookup for Current Month/Previous/Pre-Previous | Excel Discussion (Misc queries) | |||
| Subtract a future month from the current month to get remaining m. | Excel Worksheet Functions | |||
| Retrieve data for previous 3, 6, 12 month given current month | Excel Worksheet Functions | |||
| automatically update chart plotting current month and previous 6 | Charts and Charting in Excel | |||
| Calculate the first day of the month for the current month? | Excel Discussion (Misc queries) | |||
Threaded Mode
