Advanced Filter - Automatic Update
 

I'd like to allow individuals to enter in filter variables in one or two
lines and have the spreadsheet automatically process these filters and
automatically refresh the spreadsheet. Does anybody have general macro
language (i'm assuming a macro is the only way to go) to accomplish this?
(I'm guessing it would have to check to see if filter data is enterred in one
or both lines and adjust the ranges accordingly)

Is there a better way?

Thanks for any help.