Use a selection change event on the DV cell, and get the list value link by matching the selected DV Value against the list, and do a Follow Hyperlik on the matched cell hyperlink value.
Use a selection change event on the DV cell, and get the list value link by matching the selected DV Value against the list, and do a Follow Hyperlik on the matched cell hyperlink value.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote