Rankings

**bud144** · 11-22-2006, 03:51 PM

Hi
Hoping someone can please help?
I have a worksheet set up as a draw sheet for a tournament. I have a set of rankings showing all points collated from last tournament. What i want to do is set up a formula/macro so that a cell containing a player eg. the winner will be found on the ranking list and the points won will be added to the next cell on the ranking list.
any ideas anyone?
Thanks

**VBA Noob** · 11-22-2006, 03:54 PM

Can you post an example as I'm not clear on what this means

points won will be added to the next cell on the ranking list

What Points ??

Need to list Winner points, rank 2 points etc and what the next cell is ??

VBA Noob

**bud144** · 11-22-2006, 04:38 PM

Will try,
The draw sheet is set out as eg. cell a1 = runner/up, b2 = winner. say the winner is joe bloggs he will get 20points for winning.
In a separate worksheet set out for the rankings. joe bloggs is already in the rankings from previous events. I want the spreadsheet to look for joe bloggs, who on this occasion is in winners cell and add the 20 points to a cell next to his name on the ranking list.
Very difficult to explain
Thanks for looking

**Carim** · 11-22-2006, 04:40 PM

Hi,

Vba Noob is right ... tough to understand ...

Why don't you upload a zipped copy of your worksheet ...?

HTH
Carim

**VBA Noob** · 11-22-2006, 04:45 PM

Hi,

Still not clear. You say

won will be added to the next cell on the ranking list.

Is the ranking list got name, rank and running total. Is the new value add to a new column or the same column

Please be more specific

Display data in draw sheet and ranking sheet . Please your expected results

VBA Noob

**bud144** · 11-22-2006, 05:17 PM

i think ive attached a file?
if so- i am trying to get the rankings worksheet to look at singles sheet, work out eg. the winner (from the winners cell) locate the name on the rankings sheet and add it to cell I3 as wayne smith was winner. each one will be different.
Hope this helps