speeding up a loop

Can anyone suggest a more efficient way of ordering two columns so that the same values are on the same row?

column M has 16000 filled cells and column P has up to 50 filled cells, so my loop's really slow. For each cell in col P I need to move it to the p cell adjacent to its match in col M.

so I want:

1 2
2 7
3 9
4
5
6
7
8
9

to be:

1
2 2
3
4
5
6
7 7
8
9 9


Thanks!

Please Login or Register  to view this content.

hi, menos, can you post sample workbook showing original data and result you need to get?

Hi Roger, thanks so much, that works a treat! So that I learn, can I check that I have interpreted the code correctly?

Please Login or Register  to view this content.