Link to home
Start Free TrialLog in
Avatar of Dave Pitts
Dave Pitts

asked on

Editing

I need a spreadsheet withe ability to add, search, and update records
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image

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
Avatar of Dave Pitts
Dave Pitts

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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