One way would be to add the name on the end, then do a horizontal sort. You
can get the code by performing the task manually with the macro recorder
turned on.

--
Regards,
Tom Ogilvy


"Paula" wrote in message
...
I have a spreadsheet with employee names as column headings and property
numbers as rows. I would like, when I have to add a new employee into the
mix, to be able to set up a macro to insert a column, add in the employees
name, then get him/her into the correct spot alphabetically. Is there a
way
to do this?

Thanks - Paula