Filter results below each other

[alanb1976]

Hey all

Is there a way to have results of a filter automatically be added to the bottom of list?

I have a primary page where filtered results get copied to. The filter should check 3 different worksheets and display all results from the 3 below each other. So if there are 10 resulting rows from each page, it will display them in a list of 30 rows (3 x 10 rows beneath each other). The only filter macro I know specifies a range and therefore I can't have the results automatically below without knowing the exact amount of rows

Thanks for any help.
Alan

[tigeravatar]

alanb1976,

Give this a try. Run it from the "Primary" worksheet where the results will be recorded.

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[alanb1976]

Thanks. I'll give that a go