How2 automatic refresh advanced filter based on validation list?
 

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?

How2 automatic refresh advanced filter based on validation list?
 

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

How2 automatic refresh advanced filter based on validation lis
 

Thanks a lot, that seems to work just perfect, BR Kjetil

PS; a lot of well tasting products in the list, even scandinavian, if you
visit Norway, I'll invite you for a bite ;-)

"Debra Dalgleish" wrote:

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

How2 automatic refresh advanced filter based on validation list?
 

On Jul 17, 8:44 am, 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?

Test