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? |
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 |