Sorting multiple sheets at once

  • Thread starter Thread starter warchalkprinces
  • Start date Start date
W

warchalkprinces

I have multiple sheets of data and column A in each sheet is the same.
I have entered the data for column A in text on the first sheet and th
remaining sheets reference column A of the first sheet. My problem i
that when I sort the first sheet by column A, then ONLY column
changes in the remaining sheets. I need the data associated with colum
A to be sorted in ALL sheets. For example:

Sheet 1:
NAME AGE HEIGHT
susie 23 5.4
debbie 26 5.1
pasquale 30 6
helen 21 5.5

Sheet 2:
NAME FAV COLOR
susie (=Sheet 1!A2) red
debbie(=Sheet1!A3) blue
pasquale green
helen purple

So, when I sort Sheet 1 by NAME, I also need Sheet 2 to be sorted b
Name (so that I can keep FAV COLOR associated with the right person).

Any help on this would be greatly appreciated. Thanks in advance
 
Instead of using formulas like =sheet1!a1, can you find a common (unique) value
between the worksheets.

Then you could enter the keys on each sheet and use =vlookup()'s to return the
other information.
 
I think it will be much more efficient to put all your data into a
single table.

If you want to show separate lists it would be no problem because you
just use formulas similar to the one you already have in the
appropriate sheets.
 
Back
Top