Copy worksheet by date

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

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?
 
What format are you dates on the sheet tabs?
Click to expand...

I can use any date format. Currently I use Name of day month year, ex:
Wendesday Apr 11, 2005, but ANY format will do.
 
Back
Top