Attached is a "database" for Risk assessments. I want to make to mods and i'm after some guidance on how to do it:
1) Have a button that creates a new dab based on the template "OperationalProcess HIRA" sheet and then prompts for a new name for the tab.
2) For Quick access i've created a userform1 that opens with the workbook that is populated by all the worksheets in the workbook. What i want to do is for the operator to be able to filter these based on the sheet name prefix i.e - Asphalt , concrete , Aggregates etc. How can i do this from within the userform ?
I know access would be the way to go but only a limited number of people within my company have access installed so it needs to be usable through excel.
Bookmarks