Copy distinct values macro

[DRExcel515]

Is there a way to make a macro that takes the values/text I have in column B (starting in row 2 to avoid copying the header) on sheet SQL Dump and copy paste values all non-duplicate ticker symbols on a new sheet in column A staring in row 2 (again to avoid copying over the header) on sheet SD Calc?

So currently I have over 13,000 ticker symbols in column B staring in row 2 on the SQL Dump tab and need to copy over all of those tickers to the SD Calc tab starting in column A2, but only copy over a distinct list that gets rid of all duplicates.

Any help would be much appreciated!

Thanks,

 

[Joe4]

Just copy them all over, and use the built-in "Remove Duplicates" functionality Excel has.
Using the Macro Recorder, you could get the VBA code for this, if you definitely need VBA code.