View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mike@ewero.com is offline
external usenet poster
 
Posts: 2
Default 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?