Exctract Unique Branch Names

I have data in Col C on Sheet "Imported Data" . I want to copy the unique records to sheets "branches"

When running the macro the first time, It extracts the unique records. However when running a second time, it extracts all the the records in Col C on sheet "Branches"


Attached please find sample data, which contains my macro

Please Login or Register  to view this content.

thanks for the help, much appreciated