Simple Database Build

**andyaf** · 12-03-2013, 12:59 PM

Hi,

I need some help building a simple database for a flight project I'm working on. The file is attached. Tab 1 (Updated Flight list) is pulling information for a website that lists all flight times (starts on row 92). The second tab, "Selection" is a filter I've created based on a drop down menu of all airlines.

I need help filtering the data. For example, when I select " American Airlines" from the dropdown, only American airlines information should show up on the selection tab.

Any ideas how this can be done?

Thanks very much for the help!

-Andrew

**MickG** · 12-03-2013, 02:07 PM

Try this:-
Place code in "Combobox1_Change" Event Code module.

Please Login or Register  to view this content.

Regards Mick

**FDibbins** · 12-03-2013, 02:42 PM

If you add a helper column to your data (I used H) from H93 down...
=A93&COUNTIF($A$93:A93,A93)

Then I used B3 for the airline, and in B7, copied down and across, use this...
=IFERROR(INDEX('Updated Flight List'!$A$92:$G$518,MATCH(Selection!$B$3&ROWS($A$1:A1),'Updated Flight List'!$H$92:$H$518,0),MATCH(Selection!B$6,'Updated Flight List'!$A$92:$G$92,0)),"")