sorting rows

[Mike]

have a worksheet which includes coloums for employees names, days worked ,
holidays etc if i add a new employee and try to sort the names into
alphabetical order the days worked holiday numbers do not move with the
names.
I also use this to extract the weekly information to a summary sheet which
causes further problems

 

[Lainyb]

Mike

Are you highlighting all columns before applying the sort?

Try that and all relevant data for each person should be sorted.

Hope this helps.