Great macro for filtering a unique list - some fine tuning

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

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:
Range("B3", Range("B65536")
--> 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.

Please Login or Register  to view this content.

Still need help for the rest, thanks!