Filter Problem On Multiple Columns

[jwolfenstein]

Hello All,

I have a sheet that I extract three unique criteria from my table. I then use this criteria to filter the main table by those three criteria. I am extracting unique values of a window construction list, totaling and pasting to a new sheet.

I wrote a similar macro to filter a sheet by two unique criteria and it works great. The same macro on a different sheet will only work with one criteria. As soon as I add the second criteria I have no results in my table.

The first two thirds of the macro work fine. I am intending to loop this macro as soon as I figure out the filter problem. My problem starts at the loop(I think).

I have attached the file.

Thanks for any input.

John W


This is my macro:

Please Login or Register  to view this content.