View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Simonds Patrick Simonds is offline
external usenet poster
 
Posts: 258
Default 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?