I have an Excel Workbook that contains a number sheets with thousands of products. The workbook has been designed for easy navigation using VB controls etc. I am wanting to add a search feature on the main page for product code or product type.
I'm sure it is possible, could somebody please help?
Basically, at the moment the user selects the brand using a button on the main page. then a product type from the next sheet. Up comes a sheet with a list of products including Product ID, Product Type code, Description, Price etc. I have an auto filter enabled also. this is the case for each sheet containing the products.
the search feature should allow you to enter 2 options only. Product Type code and Product ID. Product ID's are unique, product Type Codes are not. Each product Type code could have one or many different products related to it but will always be on the same sheet.
Your assistance would be greatly appreciated.