M
mmattos
I'm trying to create a form where Sheet 1 cell D4 is an item drop down
list from Sheet 2 A2..A34 in which each cell is a hyperlink to
different ranges hidden in sheet 1.
What I want to happen is this:
In Sheet 1 cell D4..H4 (merged) when an item from the list is chosen I
want that particular hyperlink to open the range that's hidden below.
The end result, depending on which Item use chose in cell D4, 10
specific lines will open up on the form.
Can anyone help me?
list from Sheet 2 A2..A34 in which each cell is a hyperlink to
different ranges hidden in sheet 1.
What I want to happen is this:
In Sheet 1 cell D4..H4 (merged) when an item from the list is chosen I
want that particular hyperlink to open the range that's hidden below.
The end result, depending on which Item use chose in cell D4, 10
specific lines will open up on the form.
Can anyone help me?