N
natesteiner21
I've checked out multiple forums and haven't gotten the answer that I'
specifically looking for. I've also noticed that this forum seems to b
the best on net at this sort of thing so I'm sure I'll be able to fin
someone that can help me out.
The Problem:
I've created a worksheet that needed a list so I used the dat
validation tool and pointed it to:=$GI$2:$HV$2
Then I had to create a sub list and used the data validation tool an
pointed it to:=INDIRECT(GF$15)
Everything was working great, until, I had to change one of the "names
in the GI2:HV2 range. Now all of the data that was pointed to th
"names" in the list that have changed don't work in the sub list.
actually didn't even change any of the names in the sub list.
Any idea what I'm doing incorrectly here?
Thanks for your time.
Nat
specifically looking for. I've also noticed that this forum seems to b
the best on net at this sort of thing so I'm sure I'll be able to fin
someone that can help me out.
The Problem:
I've created a worksheet that needed a list so I used the dat
validation tool and pointed it to:=$GI$2:$HV$2
Then I had to create a sub list and used the data validation tool an
pointed it to:=INDIRECT(GF$15)
Everything was working great, until, I had to change one of the "names
in the GI2:HV2 range. Now all of the data that was pointed to th
"names" in the list that have changed don't work in the sub list.
actually didn't even change any of the names in the sub list.
Any idea what I'm doing incorrectly here?
Thanks for your time.
Nat