If data exists on Sheet2/colB but not Sheet1/colA, add it.

Not sure where to start ...I need a VBA script to do the following (when run) -

To add to an existing list of "City" names in Sheet1 (colB), based on any new "City" found on Sheet 2 (colA)

- Sheet2 constantly changes (data comes and goes).
- I need Sheet1 to be static, meaning, if I delete Sheet2, I do not lose any data on Sheet1.

I think I want to say, but not sure where to start:
If City exists on Sheet2 (column A), but does not exist on Sheet1 (column B), add the City to Sheet1(column B). -I just need the City Name, not all of the user data.

See attached example data.

Note: Sheet2 can contain anywhere from 450 to 30000 rows of data.

Any help would be appreciated

Thank-you! It works! Though, I may need to remove the dictionary element since it found Toronto and TORONTO

Yes...I think that worked.. It did copy only unique values. Though, the copied values are in uppercase, but I think I can work with that (or if needed, maybe add StrConv). Thank-you!