ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Filter based on cell contents. (https://www.excelbanter.com/excel-programming/444946-filter-based-cell-contents.html)

[email protected]

Filter based on cell contents.
 
Hello
I would like to filter a list of requirements in B5:B500, and in
C5:500 the group to which the requirement applies. Some requriements
only apply to 1 group while others may apply to all groups (There are
15 groups total). I would like to be able to enter a list of
requirements based on the Groups that are entered in cell F4, ie.,
Cat, Dog, Fish. In the alternative, I could list the groups and
utilize a check box beside that applicable groups.
Thanks in advance!

Vacuum Sealed

Filter based on cell contents.
 
Hi

You could try this link

Debra Dalglieshs "Contextures Website"

She has a miriad of DataValidation routines that may help with what you
need.

http://www.contextures.com/xlDataVal15.html

It allows you to do multiple levels of Select & Filter based on you
criteria.

HTH
Mick.




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

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