I was looking for help on how I could advance filter a list in a shared work
book.

When I use advanced filter I receive runtime error 1004.
If i hide rows it run very slow with 20 thousand rows.

Thanks in advance for any help.

and thanks to everyone who has helped me with this project over the last
month. It is just about complete. (until they decide to change everything)