There are sample files here that might help:

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

For example, under Filters, look for FL0002 - Product List by Week
Number or FL0005 - Phone List for Selected Name

Kjetil wrote:
I have a list which I want to automatically update when I select a value in a
cell from a validation list. The list will end up as a document showing only
the selected lines, but I want functionality like dynamic tables in RDB's,
not having to do all the manual updating of the advanced filter. Anyone has a
tip on what to put where, to make this refresh happen when the value in the
source-cell changes?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html