Ok, I think I get it. If we call these BackEnd.xlsx and FrontEnd.xlsm, I take it you want the user to be able to do the following:

1) Open FrontEnd.xlsm and enable macros.
2) Type in fragment of a name and/or street address, and...
3) Hit <Enter> to see listed below the rows from BackEnd.xlsx that match the criteria entered.
4) Type a value into FrontEnd.xlsm's date_of_start column, and...
5) Hit <Enter> to have that value written over whatever's in the corresponding cell in BackEnd.xlsx.

That doesn't sound very complicated. What have you already done in VBA? It sounds like you may know how to do some VBA in Access and you need a start in doing the same sort of thing in Excel, maybe?