VBA: Create unique list from range of data

[BIGTONE559]

I'm looking for an alternative method for creating a unique list from a range. I'm currently using advancefilter with the copyto range method. I would like to be able to go through my range (B10:B45) and copy unique items to a list beginning at Range(A30).

Thanks,

 

[pboltonchina]

Hi Vermont_Steve,
I haven't worked with macros for a few years now and all my codes were given by other people, so I'm sorry, but I can't help.