Active / Dynamic Filtered List (changes w/ change in cell value)
 

I'd like to be able to have a filtered list change AUTOMATICALLY based
on a criteria value (entered in a cell outside the filtered data
range). What is the simplest way to do this? Autofilter is close, but
it will not update the results dynamically.

You can use programming to update the filter if a cell on the worksheet
is changed. There are examples he

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

Under Filters, look for 'Product List by Week Number'
and 'Filter Rows for Text String'

wrote:
I'd like to be able to have a filtered list change AUTOMATICALLY based
on a criteria value (entered in a cell outside the filtered data
range). What is the simplest way to do this? Autofilter is close, but
it will not update the results dynamically.



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

I have little experience with VB, so I'll state my problem (which is similar
to tripp's regarding the dynamic autofilter) to see if I can receive any
specific suggestions. I have a 7-sheet workbook. the 'master' sheet
contains data automatically imported from a CSV file (approx. 101 col by 800
rows). The remaining 6 sheets filter off of a single column in the master
but use different filter conditions. The autofilter almost works, until the
master sheet is updated upon opening the file. I have looked at both of the
files Debra suggested, but I do not speak that language. If all else fails,
is there a way to update the filter of each sheet using a macro? Thanks in
advance for the help.

"Debra Dalgleish" wrote:

You can use programming to update the filter if a cell on the worksheet
is changed. There are examples he

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

Under Filters, look for 'Product List by Week Number'
and 'Filter Rows for Text String'

wrote:
I'd like to be able to have a filtered list change AUTOMATICALLY based
on a criteria value (entered in a cell outside the filtered data
range). What is the simplest way to do this? Autofilter is close, but
it will not update the results dynamically.



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

well, sorry to answer my own question, but I recorded a macro to update the
each sheet's filter when I press a keyboard command (ctrl+shift+u). New
question . . . is using the 'view code' for each sheet like running a macro
continuously? To make the update dynamic, would it be as simple as copying
the macro code for each sheet into its 'view code' area? Thanks.

"flaterp" wrote:

I have little experience with VB, so I'll state my problem (which is similar
to tripp's regarding the dynamic autofilter) to see if I can receive any
specific suggestions. I have a 7-sheet workbook. the 'master' sheet
contains data automatically imported from a CSV file (approx. 101 col by 800
rows). The remaining 6 sheets filter off of a single column in the master
but use different filter conditions. The autofilter almost works, until the
master sheet is updated upon opening the file. I have looked at both of the
files Debra suggested, but I do not speak that language. If all else fails,
is there a way to update the filter of each sheet using a macro? Thanks in
advance for the help.