CaptRon
02-08-2010, 12:04 PM
I hope to find some help with a project I'm working on. I've got an Excel spreadsheet filled with data (names, locations, job descriptions, etc.) ...each row a record relating to an employee.
I need to create a userform that permits the user to:
1. add, edit, and delete records
2. search records by one or more criteria
3. create a variety of reports based on filtered records
Access is not available to us, so I'm left to try this in Excel.
I've created a userform that will allow the user to add records and search one-by-one via a set of arrows, but that's as far as I've been able to get.
Does anyone have any examples or know where I can get more information specific to the needs noted above?
Thanks,
Ron
I need to create a userform that permits the user to:
1. add, edit, and delete records
2. search records by one or more criteria
3. create a variety of reports based on filtered records
Access is not available to us, so I'm left to try this in Excel.
I've created a userform that will allow the user to add records and search one-by-one via a set of arrows, but that's as far as I've been able to get.
Does anyone have any examples or know where I can get more information specific to the needs noted above?
Thanks,
Ron