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?
|