Editing

Please elaborate.

Problem unclear

Dave, firstly, welcome to Experts Exchange.

To get some meaningful help here, you'll need to provide some meaningful information. Please explain what exactly you're trying to achieve and consider providing a sample workbook that you may be having problems with by using the Attach File function. The more information you provide, the more helpful experts answers can be.

Regards, Andrew
EE Topic Advisor

Hi Andrew,

Firstly many thanks for coming back to me. And firstly apologies for the lack of clarity.
I have attached the file for review and guidance.
if I select Find next and select the record, edit it and then select the current record it adds a new record !!!
This was my first attempt at VBA !!!!Skills-Matrix-07-04-17-.xlsm

Your workbook's code is password protected. Please supply a workbook that's not protected or the password.

I need a spreadsheet withe ability to add, search, and update records

That's called a database. Check out Microsoft Access.

Hi Andrew
Password 'jasper'

Thanks

Dave

Please describe, step by step, how I can reproduce the problem.

Hi all Password is 'jasper'

Did you see this request of mine?

Please describe, step by step, how I can reproduce the problem.

Excellent Response from Roy. Saved me a lot of time and effort

Pleased to help Dave