Sorting question

[Patrick Simonds]

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?

 

[Nigel]

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.