Modify VBA to get rid Duplicated String when Transpose-Index/Score & String associated to.

Hi,
I'm wondering if someone help me to modify the following Code?
My workbook have two sheets "Records" and "Ouput",
On Column A2:A37 The sheet Records has Alphanumeric String and
on Column B2:B37 Has Scores (Alphanumeic as well)
Note that some String from Col A and Scores Col B are duplicated
what the code do:
it get the Scores (Col B2:B37) and copy as unique score on Sheet Output Col M1:M17
Then extract any String associated to each Score and copy next to it on same sheet Ouput Col O1:V17

NOTE 1: I need to Paste but starting on Row M2 of Ouput?, is pasting in Row M1, and i can't find where to change it

NOTE2: The code is working find but on Range N1:V17 is copying unwanted Duplicated String on Single Score Row, It does'nt matter if any other string appear multiples Times on Multiples Scores But Just once (per row).

See bellow The Ouput with Unwanted Duplicated String that i need to get rid of (red string).


Score ID __STRING
40 -----> 15
20 -----> 18 18
17 -----> 03 10 06 07
13 -----> 23 23 23
12 -----> 14 16 30
11 -----> 05 12
9 ------> 32
8 ------> 23
3 ------> 34 29 34 29
5 ------> 09 01
4 ------> 21 11
2 ------> 17 20
1 ------> 33 26 08 04
0 ------> 02 13 36 28

The Ouput what i need with Unique String that belong to each score
===========================================
Score ID___STRING
40 -----> 15
20 -----> 18
17 -----> 03 10 06 07
13 -----> 23
12 -----> 14 16 30
11 -----> 05 12
9 ------> 32
8 ------> 23
3 ------> 34 29
5 ------> 09 01
4 ------> 21 11
2 ------> 17 20
1 ------> 33 26 08 04
0 ------> 02 13 36 28




Im using this code
============

Please Login or Register  to view this content.

Thanks a Millions !!!!

Hi Mr PCI

Run the code and display: Run-Time error Select method of Range Fail

The Debug Hilight Rng.Select

Hi Mr. PCI,

I'm really sorry for this false/positive (by my side)
Your code is Working Good, My mistake, when compare to previous Code with yours I left one Breakpoint On.
and that's why I was getting the error


I Apologise and Thank you so much!!!!!

Hi Winon,


Thank you but after removing a breakpoint (on the other code) it works fine.

Btw Thank you for the Error Tips


Regards

AndyJr

Hi Mr PCI,

I just understand approx 40% of the code, but it looks beautiful!


Thanks!!