sorting rows
 

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

sorting rows
 

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.
--
Lainyb


"Mike" wrote:

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