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

[trippknightly]

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]

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

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

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

 

[flaterp]

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.

 

[flaterp]

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.