sorting 3 ranges at once

[d0wnt0wn]

i have a spread sheet that i use for a pool league i am in.... in one sheet i enter all of the players scores.... in another sheet i have a consecutive wins spreadsheet set up that needs all of the players to be listed twice on the same sheet.... the sheets are all linked together like this...

score sheet names =top list of names on consecutive sheet ... and the bottom set of names on the consecutive sheet = the top set of names... the name portion of these are all identical... but the info to the right of them is all different.... if i try and sort 1 by itself it screws up one or both of the other lists.... the lists are getting so long tho that it is hard for me to find names and I would like them all to be alphabetical.

any way for me to sort 3 identically sized ranges at the same time???

 

[Fergus]

Hi d0wnt0wn,

Thinking out loud without really knowing your sheet layouts. Can you not make the first columns of the second and third sheets read something like =Sheet1!A1, Sheet1!A2 and so on down the page and then use a VLOOKUP to get the rest of the pages. Then when you sort the first page the other pages will automatically re-arrange the first columns to match the first page with the rest of the data "looked-up" using col1 as the lookup criteria.