Dave Pitts
asked on
Editing
I need a spreadsheet withe ability to add, search, and update records
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
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
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
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.
ASKER
Hi Andrew
Password 'jasper'
Thanks
Dave
Password 'jasper'
Thanks
Dave
Please describe, step by step, how I can reproduce the problem.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi all Password is 'jasper'
Did you see this request of mine?
Please describe, step by step, how I can reproduce the problem.
ASKER
Excellent Response from Roy. Saved me a lot of time and effort
Pleased to help Dave