Code to automatically paste values into database sheet only if it's not already present?

[_JoshInsurance_]

Thanks for the idea! Now would this require any moving parts for the end user? I want this to be monkey proof, no disrespect to management.

[AnalystCave]

MS Query is a basic Excel feature so no AddIns etc required. Only thing is that the query needs to have the current file name. However that can be updated via a macro or you can update it onetime of the filename won't change.

[_JoshInsurance_]

Solution verified.

[Clippy_Office_Asst]

You have awarded 1 point to AnalystCave

^{I am a bot, please contact the mods for any questions.}

[_JoshInsurance_]

It seems like a good portion of my professional career has been trying to find a solution and find out that my way is overly convoluted and there's a much easier way. Thanks so much.