Hi All,
I'm working on a spread sheet that only shows data entries in a table based on data entered in by the user. I created an example using airline arrival and departure times.
What I want to do is have the user select the Airline they want information on from a drop down list of all the airlines. That turns on a filter which shows only the data for the airline selected. I got this working already as you will see in the sample sheet.
The next part is more tricky. There are 3 other cells below the airline selection cell. The first is threshold. I would like this to control column F which is the detention time of the aircraft. So if it is set to 0:30:00 it will filter out any flights that were not in detention for less than 30 minutes.
The other two cells set the date range for the data. Cell B3 should filter out any dates before (less than) its value, and allow everything greater than (after) its value in the arrival column.
Cell B4 is the opposite as it is the departure date and time. It should filter out anything from the departure column that is after (greater than) and allow anything that is before (less than) it in the filter for that column.
Any help is much appreciated!
Thanks,
Neo
Bookmarks