copy uniques to sheet 2

[makinmomb]

manually steps

highlight a1 to d1 , copy paste to sheet 3
highlight a2 to c2 , copy paste to sheet 2
highlight a3 to c3 , copy paste to sheet 2
highlight a4 to e4 , copy paste to sheet 2

So the macro to continue and complete all , to row 44,444

Find attached

[nankw83]

Hi makinmomb,

Can you elaborate more on the criteria of selecting which sheet to paste the data in ? i.e. sheet2 or sheet3 ?

[makinmomb]

This is called SINGLES to sheet2

AEEIORT 2 ETAERIO

This is called MULTIPLES to sheet3

AEILNOR 4 AILERON ALERION ALIENOR

[nankw83]

Based on my understanding & your sample file, try below code ...

Please Login or Register  to view this content.

[makinmomb]

Thank u was light , it scanned 44,444 words and pasted all at less than 5 seconds