Extract unique values...with a twist

Hi All,

I need help with a vba script.
I have two lists, a couple of columns apart. The columns contain, and must contain, blank spaces. The number of rows in each of these columns varies.

I need to be able to extract unique values from each of these, and combine them into one column.

I have found other scrips online which kind of do the trick but:
1. Break when the range selected goes pass the last cell with values
2. Are assigned to two different buttons on the same sheet (I tried using one script and one button per column, and then combine)
3. Can, seemingly at random, produce a list of unique values with a bunch of blank spaces in random places.

Any ideas?

Hi !

Try an advanced filter …

I don't want to manually be filtering anything - I want to just run the script and not have to alter the original list.

Doable via an advanced filter ! Another way via a Dictionary. See both in VBA inner help …

Try

Please Login or Register  to view this content.

This works wonderfully, except the headings of the columns are also in the 'Unique' column.

Hi Robert,
Thank you very much for your help. I am getting an error at Sub Macro1(). ' Expected end sub'

Then change 2 to 1
Range(e & "1:" & e & ....

Perfect. Thank you very, very much!

Final query: Can you recommend a VBA training online resource? I have tried a few over the years, and I must admit they are hard to follow.