Fairly inexperienced with VBA, and am trying to setup a workbook that I can paste a data set into one sheet (update data), then run some VBA to check a different sheet (data insert test) for if a key exists (notification) and insert the data there to update it or add the new key(s) at the end of the data. Below is the general flow of what I'm trying to do, as well as an attached workbook with how far I've gone. Could be using the wrong approach with my code, but if anyone could help me out that would be great, thanks.
If (notification) exists in "data insert test"
then update (order,test1,test2)
Else insert (notification,order,test1,test2) in last empty row