How do you keep related data on multiple worksheets in order when you sort
the top worksheet

I don't use formulas like:
=sheet1!a1
in those other sheets.

I try to find a unique key field (column) and populate those other worksheets
with the same keys (just copy|paste--not formulas).

Then I use =vlookup() or =index(match()) to return the values corresponding to
those unique keys.

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

aces2 wrote:

How do you keep related data on multiple worksheets in order when you sort
the top worksheet

--

Dave Peterson