How do I merge two columns on different sheets and alphebtize the final list.

Basically, I am creating a master product list in Sheet "LookupList". I will use all the products on Sheet "LookupList" in Column A2 down to the first blank row. Then I will copy Sheet "ExtFile" Column A2 down to the first blank row and add it to the bottom of Sheet "LookupList" and then finaly alphabetize the product list and removing any duplicates. Or should I remove duplicates before I alphabetize? Then I will have my updated Product list! Most everything workings, except when I run Sub CopyAndRemoveDups() it copies all of the other figures in the Sheet "ExtFile" Columns A - F and brings them over to "LookupList". Rightfuly so, because I have told it to do that! However, can someone tell me how to modify the code so that it only copies column A of Sheet "ExtFile". I do not need all the other columns in my master product list.

Please Login or Register  to view this content.

Lastly, the list never gets alphebtized and I'm not sure why?

Please Login or Register  to view this content.

Is there something wrong with this code? In order to run the merge, goto Sheet "LagTime" and click Merge button.

Thanks for your help!
redsab

It's a typical use of the Scripting Dictionary
See code here after to merge data

Please Login or Register  to view this content.