Hi all,

I have new spreadsheet I'm working on and basically I'm trying to allow the user (me) to type an address in the search box to show the details of the address (database on second sheet) in the lower table but then also be able to edit the table below and via a macro have that info overwrite what is stored on the database.

The search works, I have removed the macro so you don't have to open a workbook with unknown macros on it, but basically you start typing and it fills the table below it with the 10 closest matches and you keep typing until the address you want is in row 1 of the table, this then completes the lowest table with the info from the database for that address using INDEX/MATCH.

I would like to then be able to change the data in that table and have the changes saved back to the database, also if possible add new entries using the same method which would be added to the next empty row in the database.

Any help appreciated as always.

cc01.xlsm