Hi Steve:

Why don't you make three macros that will sort the data based on one of the
three sort keys. Then you just click the sort key and it will sort it.

Much easier than keeping two duplicates of the original data.

BTW you need to write an on change macro to pick up changes and replicate
them through the other two sheets.

It is not as easy as they are in different orders. So you need to use the
unique key to find them.

If you post a sample of your DB maybe somebody coluld help with a sort
routine.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Steve" wrote:

I manage a data base consisting of names, addresses including unit and phase
numbers. On worksheet one, I have the data sorted by last name, on worksheet
two I have the same data sorted by unit number and on the third worksheet I
have the data sorted by phase number. How can I make a change to worksheet
one and those changes be made on worksheets two and three?