Player score Card Macro

[makinmomb]

Raw data on a to F

I need on H to O the macro to compile history of each player for all rounds

Macro should be able to work for 100 players too , in this tour players are only 10

I have compiled sample of output for 2 rounds , macro to finish all rounds , if scores are 508-313 ,
macro needs to go look who the player is at 313-508

[xladept]

Try this:

Please Login or Register  to view this content.

[davesexcel]

Extract the strings and use find.

Please Login or Register  to view this content.

[makinmomb]

davesexcel awesome , thank you so much for this beautiful piece , wow

[makinmomb]

xladept thanks too , it gave some error , missing variable

[xladept]

I wonder where the problem is? Missing variable - which code was highlighted - it ran nicely on your sample

[xladept]

Maybe:

Please Login or Register  to view this content.

[davesexcel]

I wonder where the problem is? Missing variable - which code was highlighted - it ran nicely on your sample

This is where it errors for me, when I step through the code, N =nothing
10-21-2017 1-00-28 PM.jpg

[xladept]

@ davesexcel - thanks Dave - I think my last post (finder for xlPart) might just have fixed that

[davesexcel]

@xladept Yes, that works, and it's looks great

[makinmomb]

davesexcel i needed a small favour , i wanted the A which is the players position per round to go on column 0 , so that i can know the fluctuation of the player position wise , find attached world scrabble championship 8 rounds played today , which fully works according to your macro