Okay so far i have this:

Please Login or Register  to view this content.
Only problem being that it doesn't only copy and paste the unique values, because the other columns in the range have data in. Therefore the code can only be applied to a single column.

So ideally i'd need a way to copy and paste the unique cells in a range OR a way for it to repeat copy and paste the unique columns separate from each other without having to keep copy and pasting this code for every column i wish to do this for