View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dpchris@gmail.com is offline
external usenet poster
 
Posts: 7
Default 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