Need to copy store names from sheet1 to sheet3 and remove duplicate names

Hi,

I have attached the file with three sheets and here is what I need to do using macro.

Sheet1 has list store names in column "B" starting from row2
similarly sheet2 has list store names in column "A" starting from row4

Now I would like to first copy list of all store names from sheet1 to sheet3 column "A" and then would like to append store names from sheet2 to sheet3 column "A".
Once all names are captured in column "A" sheet3, duplicate store names should be removed from sheet3 so that only unique names are available....

Please help me with macro code for the same.

Thank you in advance.

Another option:

Please Login or Register  to view this content.

Hi sktneer,

I tried with your code but there is some issue, once I execute the code, there are still duplicate store names displayed in sheet3 . example: "CROSBY" is reflecting twice...

Please advise.

Hi Stnkynts,

tried your code, but there is issue once I execute store names in sheet3 are not displayed properly.....
I mean in sheet3 few rows get hidden and spaces are placed in between rows