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?

Copy worksheet by date
 

What format are you dates on the sheet tabs?

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.