Friday, November 23, 2012

yogi_Pull Data From Spreadsheet Standings For Position Sales And ReOrder Pulled Data By Rank In Ascending Order

                                          Google Spreadsheet   Post  #884
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Nov 23, 2012
user batt1eship1 said: (!mydiscussions/docs/OxS_6fF5Flk)
I have created two spreadsheets, one that has a ranking of names, so:
Sheet 1 (Rankings Page)
1 John AZ
2 Bill CO
3 Joe NY
Sheet 2 (Joe's page)
Joe Rank 
So, i want "Rank" on Sheet 2 to pull Joe's rank of '3' from sheet one and import it into 'B' of sheet 2... so that if sheet 1 was resorted, and let's say i moved Joe to No. 2, Sheet 2 would reflect the new rank of 2 and import "2" into column "B" of sheet 2.
Hope that makes sense.
Ok, I made the question a little more simple, direct and I have provided the "spreadsheet" links below, which are shared. I have also described what i want on each spreadsheet, but go to the first link and then the second. 

 following is a solution to the problem