Multiple Combo Boxes to return data

S

Smythe32

Hi.

Any help would be great.

Sheet1 has 5 columns of data
City State Company Code Date

There are multiple entries for each column.

On sheet 2 I want to have 5 combo boxes(city, state, company, code,
date) so that they can request data that meets their criteria. They
can should be able to retrieve all 5 columns of data with each search.
A search can consist of the value in one combo box or 2 or all. Ex:
If I want to search by city and state only those combo boxes will have
a selection. I would like the data returned on sheet 2.

Any thoughts on this?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Look Up Multiple Values And Returning One Value 3
Index/Match Functions to Return Concatenated Response 4
Need Help with a VBA subroutine 0
COMBO BOX vs Uppercase 6
Vlookup with multiple fields that need to match 1
INDEX_MATCH or VLOOKUP with multiple criteria? 4
Query to select individual records 4
Formula for multiple rows of same value... 2

Top