T o amend an entry you would need to find the correct row by using the .FIND method based on the ID.
Would you be able to assist with this part? I tried to google/YouTube what to try next but I have no idea what to do . I have attached the updated example workbook with the code you suggested for your reference.
The only problem I need to sort out is to amend an entry and save the changes back to the DB sheet. I am also not sure should one create a separate module for this action? My thinking was that when you click the "save button then the code would check to see if the Entry# in Input1 sheet in cell "C5" exists in the DB sheet with the FIND function as you suggested, if it does not exist then it will run Module4 code (to add new entry to last line), but if it does exist then it would run another i.e. Module (Module5) code to update and overwrite that specific Entry# row? Or is there another way to achieve this?
If you could help with this last code I would be super grateful!