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