2 way self filling data information sheet

[Berry1904]

Hi all,

I am looking for a way to inplement data from a datatab in to an Excel registrationform.
But, if they want, it can be overwritten.

Also, I would like this datatab to be auto learning.
So when new information is entered, it stores the latest info.

Now I am working with Xlookup, but it only works one way.
If somebody enters the Contact#, the details are being filled in.
I would love to see the Data being filled in if (for example) a new Contact is entered.
So it needs to lookup if the # also excists, if not it needs to create a new line with all details.

I added a picture of the 2 tabs.
It works if I fill in 127 or 115, but when I create a new one, (for example 130), I want the new data to go to the Data tab in a new, empty colomn.

Is this even possible in VBA?

 

[mumps]

It is hard to work with pictures. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach screenshots (not pictures) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).