Update an original list only with new elements from other source(s)

[Vladimir Atanasiu]

Hello!

I have an original list of products (see Table 1 from the attached document), on the basis of are generated periodically inventory lists (Table2). The inventory lists include items, already registered, but in the warehouse may be found also some new elements, that are not included in the original list. My question is how could be updated automatically the content of mother list, only with the new elements that are not identified before within it (see Table 3). I wish the new items to be part of Table 1, Table 3 is just to clarify the final structure of Table 1.
Thank you!

[Squeaky]

Here is my semi-automatic solution. If a macro solution is desired you will want to post on the VBA portion.

Squeaky

[Squeaky]

Let me know if you have questions.

[JeteMc]

You could also accomplish this using the remove duplicates feature (Data tab)
1. Select cells C4:C12
2. Press the Ctrl + c keys or select Copy (Home tab)
3. Select cell A15 and press the Ctrl + v keys or select Paste (Home tab)
4. Press the Esc key
5. Select cells A1:A23
6. Select Remove Duplicates from the ribbon on the Data tab and select OK
Let us know if you have any questions.