Why not just let the users use the AutoFilter dropdowns on 'page a'?

However, there are some sample workbooks here, that may give you some
ideas for getting started:

http://www.contextures.com/excelfiles.html#Filter

ReportMaster < wrote:
I have exhausted all of my attempt to figure this one out. If anyone
has any code that can help it would be very appriciated.

I need to filter 'page a' by selecting from comboboxa and comboboxb
which are on 'page b'. When the user clicks on a submit button they
then have to be directed to the filtered data.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html