to add new name

G

Gord Dibben

Data>Sort

Make sure you pre-select all columns and rows that should stay together then
sort on the name column.

Experiment with a copy of your worksheet if unsure of the above.


Gord Dibben MS Excel MVP
 
Top