I agree, it's a lot easier to understand with a file. Sorry for not putting it in the first place.
So I want to filter a list to another place as unique and keep the destination place formatting like colors and heading. Added later: Also it would be nice if the destination column could be colored so, that after the last unique item there would be two light blue colored empty cells below it.
The macro code comes with the file and I change the line to match the layout:
--> This way it doesn't work correctly, because it's duplicating the first value.
--> You can change in the code B3 to B2. But then I have wrong heading name.
Also the first way deletes some colors.
Then the macro should first perhaps to empty the destination values, because it is not copying anything if there are values?
EDIT: Actually just found a simple macro to clear cells to include in the code.
Still need help for the rest, thanks!