How do you keep related data on multiple worksheets in order when you sort the top worksheet
A aces2 Dec 22, 2005 #1 How do you keep related data on multiple worksheets in order when you sort the top worksheet
D Dave Peterson Dec 22, 2005 #2 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()))
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()))
