Second Data filter hides all rows

[Ochimus]

Attached file gives End User option of choosing two criteria (Airport and Date) in cells on the "Extract" sheet, which filter the Table on the Database sheet, leaving only the two rows showing that match both elements, which the next stage of the Code will copy to row 4 downward on the Extract sheet.

"Filter" code works perfectly on first stage matching the airport. But the second stage, which should then hide the two rows not matching the Date, hides ALL the rows except the Header.

Please Login or Register  to view this content.

(And yes, I am aware the End User can simply use the inbuilt filter on the table itself to achieve this, but this is the way they want to do it.)

Hopefully someone can see where I am going wrong?

All suggestions, recommendations and solutions welcome as ever, as the principle has to be cascaded across fourteen criteria in the "real" sheet!

Ochimus

[xladept]

Here thanks to Ozgrid is a working solution

Please Login or Register  to view this content.

[Ochimus]

xladept,

Apologies for not thanking you sooner for the prompt reply. RL in the way.

Will try this out this evening, and hopefully it will resolve the issue.

Ochimus

[xladept]

Yeah, who would have thought the date filter wouldn't work for the equal situation?

Thanks for the rep!