ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   AutoFiltering by combobox selection (https://www.excelbanter.com/excel-programming/293701-autofiltering-combobox-selection.html)

ReportMaster

AutoFiltering by combobox selection
 
I have exhausted all of my attempt to figure this one out. If anyon
has any code that can help it would be very appriciated.

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

Thanks

--
Message posted from http://www.ExcelForum.com


Debra Dalgleish

AutoFiltering by combobox selection
 
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



All times are GMT +1. The time now is 09:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com