Can you help me regarding on this?
I have excel work book with function add and search.
i want to modify it.Unfortunately, i am still a beginner.
Some of the codes here are from other forums, i modify some of those codes.
here is my problem.
"Add" function, if there is duplicate on the data to be add. Message will pop-up "already existed, Do you want to update?". if user opt to update, program will update the existing data on "database sheet".
For "search" function, the search results that has been displayed on "view" sheet will link to the database. So that when user click the search result it will go to its specific location on database sheet.

here is my workbook: