Sorry, it's a bit of a generic question. I have a workbook (link attached) where I'd like users to be able to enter and update information data via some type of form. In the linked spreadsheet I've created a UserForm to display each record (row of data) which is indicative of the information contained in each record.
Ideally I would be looking at the user being able to enter the initial elements of a record, then having the ability to view/ scroll through individual records, with the ability to filter to particular records, for example based on date of creation, or where blank fields exist, so the user can prioritise tasks associated with each record.
I was wondering if anyone could suggest a way of doing what I want to achieve above? Would a UserForm be the best option or would Active X input be a better option, or other option. I'm not looking for someone to create it, just ideas on the best way to achieve what I want. The spreadsheet could hold hundreds of records so maintaining it could be very cumbersome via the raw table.
Example workbook
Thank you.
Ideally I would be looking at the user being able to enter the initial elements of a record, then having the ability to view/ scroll through individual records, with the ability to filter to particular records, for example based on date of creation, or where blank fields exist, so the user can prioritise tasks associated with each record.
I was wondering if anyone could suggest a way of doing what I want to achieve above? Would a UserForm be the best option or would Active X input be a better option, or other option. I'm not looking for someone to create it, just ideas on the best way to achieve what I want. The spreadsheet could hold hundreds of records so maintaining it could be very cumbersome via the raw table.
Example workbook
Thank you.