I've checked out multiple forums and haven't gotten the answer that I'm specifically looking for. I've also noticed that this forum seems to be the best on net at this sort of thing so I'm sure I'll be able to find someone that can help me out.

The Problem:

I've created a worksheet that needed a list so I used the data validation tool and pointed it to:=$GI$2:$HV$2

Then I had to create a sub list and used the data validation tool and 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 the "names" in the list that have changed don't work in the sub list. I 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.

Nate