Matching data from several worksheets and placing in one worksheet

**jprice** · 02-24-2010, 02:42 AM

I have rankings from several different sources all with different rankings for different people with a different number of people in each set of rankings. I would like to match the names from each ranking set and place the corresponding ranking into one worksheet. I have done this without the code but over the course of the next couple of months the rankings will be changing. I have them importing from the web so when they update I would also like for my rankings to update. Attached is the rankings each in their own worksheet. The final sheet is what the end product looks like. Thanks for any help.

**JBeaucaire** · 02-24-2010, 03:04 AM

If they are importing from the web into Sheet1-Sheet6 as shown, you can get most of your list with simple formulas on Sheet7, as shown on the attached. All the columns except column B are the result of INDEX/MATCH formulas, an average in the last column.

The only macro you need is to SORT column B on sheet7 based on the value in column M.

**jprice** · 02-24-2010, 03:29 AM

Originally Posted by JBeaucaire

If they are importing from the web into Sheet1-Sheet6 as shown, you can get most of your list with simple formulas on Sheet7, as shown on the attached. All the columns except column B are the result of INDEX/MATCH formulas, an average in the last column.

The only macro you need is to SORT column B on sheet7 based on the value in column M.

Thank you. I wasn't even aware of that formula. I assume that the same formula can also be placed in a macro, correct?

**JBeaucaire** · 02-24-2010, 08:27 AM

Yes, of course, any formula can me inserted via macro, though on your sheet, I wouldn't see the need, once on the sheet7, the items should continue to work based on whatever order the names are there in column B.

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)

**jprice** · 02-24-2010, 09:52 AM

Originally Posted by JBeaucaire

Yes, of course, any formula can me inserted via macro, though on your sheet, I wouldn't see the need, once on the sheet7, the items should continue to work based on whatever order the names are there in column B.

This project is alot more complicated than this one issue so I'm sure that I will be back for more help. Thanks for your help and your hasty responses.