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.