Copy and paste values but exclude duplicate listing

[Brew]

How do I create a formula or macro that will copy the list of values in the range BQ5:BS18 and paste into CH5:CJ18, but exclude any cells from the list that are duplicates.

 

[Sprucy]

Hey Brew,

Do you really need a macro?
If not, you could....
Select your range (BQ5:BQ18)
Then go to Data > Advanced Filter > Copy to another location
Specify your range, BQ5:BQ18
Copy to: CH5:CH18
and so on for each columns....
Check mark the Unique Records at the bottom....

See if this works for you...
I know there's a better way, but this will get you started...

Cheers,
Sprucy

 

[Brew]

Thanks for your help, however this does not work for my purpose, because the original data get it’s values from formulas referencing other cells, therefore, giving formulas as results referencing other cell locations. Does anyone have any other ideas?, maybe a macro is a better solution.