Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting question
Not sure how to describe but will do my best:
I have a workbook with 12 worksheets (one for each month) on all 12 worksheets columns A "Names", B "Group", C "Status" are the same. So I had planned to enter that data on worksheet one and then have all the other worksheets point (by formula) to the first worksheet. Makes it much faster to add a new name (do it once on the first worksheet and then it is automatically placed on the other 11 worksheets). Well that part was easy. What I need to do next is to Sort by name so that names appear in alphabetical order. My problem is that I can not sort all 12 sheets at the same time. As soon as I sort sheet one the name get resorted on the other 11 worksheets but the information in the other columns is now associated with the wrong name. Any ideas out there? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting question
You will need to sort each sheet individually, but your links will still be
problem so they will need to be broken first.. If you need to maintain date related information on each person have you considered placing all data in one sheet? Effectively creating a database, your sorting (an many other uses) will be far simpler. You could then create a display area on the same sheet or another sheet to show each month based on the source data. -- Cheers Nigel "Patrick Simonds" wrote in message ... Not sure how to describe but will do my best: I have a workbook with 12 worksheets (one for each month) on all 12 worksheets columns A "Names", B "Group", C "Status" are the same. So I had planned to enter that data on worksheet one and then have all the other worksheets point (by formula) to the first worksheet. Makes it much faster to add a new name (do it once on the first worksheet and then it is automatically placed on the other 11 worksheets). Well that part was easy. What I need to do next is to Sort by name so that names appear in alphabetical order. My problem is that I can not sort all 12 sheets at the same time. As soon as I sort sheet one the name get resorted on the other 11 worksheets but the information in the other columns is now associated with the wrong name. Any ideas out there? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting question | Excel Worksheet Functions | |||
sorting question | Excel Discussion (Misc queries) | |||
Sorting Question | Excel Discussion (Misc queries) | |||
Sorting Question | Excel Discussion (Misc queries) | |||
SORTING question | New Users to Excel |