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've created a combo box within the userform1 but how would i get it to list the prefix of the sheetnames to allow me filter based on prefix ?
I've created a combo box within the userform1 but how would i get it to list the prefix of the sheetnames to allow me filter based on prefix ?
