I have a workbook that includes three worksheets. The first one (shown in image) is where you can choose a choose from the first and then the second drop down list. The company's that sell those products then appear in the table below. the second sheet and third sheet is all the workings behind this.
I am trying to get a separate search box where I can enter a company, sales personal, product, or any other info associated with the company I have entered in the other worksheets and then be able to return the information, just like the drop down list. I know about the combo drop down list and search box and this is not what I'm looking for.
I am trying to get a separate search box where I can enter a company, sales personal, product, or any other info associated with the company I have entered in the other worksheets and then be able to return the information, just like the drop down list. I know about the combo drop down list and search box and this is not what I'm looking for.
