With great difficulty if you have multiple worksheets linked together.

Not knowing the structure of your intertwining, it would be hard to hazard a
guess.

You could try the macro recorder on a copy of your workbook.

Make sure you select all columns before sorting.

You can only sort on one worksheet, however.


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 13:14:00 -0700, SLU
wrote:

How do I create a macro that allows me to sort alphabetically the names
without losing the metrics associated with the name? I have multiple tabs
that are intertwined.

Please help