Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Rows | Excel Worksheet Functions | |||
How many rows after sorting? | Excel Discussion (Misc queries) | |||
sorting out rows | Excel Worksheet Functions | |||
Sorting rows | Excel Worksheet Functions | |||
sorting rows | Excel Worksheet Functions |