Good morning,

Here's my dilemma:

I have a list of client data, organized on rows with several parameters in each column (i.e. Column A: Name, B: Address, C: Phone Number, D:Client Number, etc.). I have a master list of all clients in worksheet 1, and a list of clients that owe $ this year in worksheet 2 (not exactly this simple, but this is the idea). I have the info in worksheet 2 linked directly from worksheet 1, so that when I make changes to a client's info on the master list, it's automatically updated on the condensed list-- i.s. so that I only have to do it once.

Sometimes I need to organize worksheet 1 with the rows sorted alphabetically by name, and sometimes chronologically by client number. However, when I sort worksheet 1, worksheet 2 also sorts, and my list of clients that owe $ this year is no longer accurate.

How can I have the two worksheets set-up so that the info is linked and updated, but when I sort in one worksheet, the other is not affected? Is this even possible?

Thanks for thinking about it!

Cheers.