Hi! I have an existing macro that reformats several things on a workheet and
then copies the worksheet to another worksheet in the same book and sorts it
in a different order. I then have to manually rename the two worksheets -
the first one to "20081030 by Name" and the second tab to "20081030 by Loc",
where 20081030 is the date.

What would I add in the macro to change the two tabs automatically to the
current date and "by Name" and the current date and "by Loc"?

Thanks in advance for your help!

Liz