| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy worksheet by date
I need to copy a worksheet from a workbook of about 12 worksheets.
Each worksheet is named the date it was created. No two worksheets have the same date. I want to take the oldest and make it the current worksheet, like a workbook that revolves. I want the oldest to be renamed the current date (today()). How do you select the oldest worksheet? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy worksheet by date
What format are you dates on the sheet tabs?
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy worksheet by date
On Apr 27, 11:50 am, Dave Miller wrote:
What format are you dates on the sheet tabs? I can use any date format. Currently I use Name of day month year, ex: Wendesday Apr 11, 2005, but ANY format will do. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy date from worksheet to another worksheet (same File0 | Excel Discussion (Misc queries) | |||
| Copy worksheet to another worksheet and the date is plus 1 day. | Excel Worksheet Functions | |||
| How do I copy a date in a worksheet cell to another worksheet? | Excel Worksheet Functions | |||
| How to copy data as per date into new worksheet? | Excel Programming | |||
| Copy Data as per date into new worksheet. | Excel Programming | |||
Hybrid Mode
