Copy worksheet by date

's Computer Specifications

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?

's Computer Specifications

What format are you dates on the sheet tabs?

's Computer Specifications

On Apr 27, 11:50 am, Dave Miller <david2.mil...@citigroup.com> 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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy partial worksheet to a different worksheet based on date??	Kevin J Prince	Microsoft Excel Discussion	4	8th Sep 2007 07:01 AM
copy date from worksheet to another worksheet (same File0	=?Utf-8?B?d2FtYWprcg==?=	Microsoft Excel Misc	1	15th Jan 2007 03:32 PM
Copy worksheet to another worksheet and the date is plus 1 day.	=?Utf-8?B?U3RldmVk?=	Microsoft Excel Worksheet Functions	0	19th Jul 2006 04:15 AM
How do I copy a date in a worksheet cell to another worksheet?	=?Utf-8?B?SmVubkxlZQ==?=	Microsoft Excel Worksheet Functions	3	17th Feb 2006 05:38 PM
Copy data in new worksheet as per date	=?Utf-8?B?VGl5YQ==?=	Microsoft Excel Programming	0	1st Aug 2005 08:01 AM