Hi, new to the forum, and pretty new to Excel, though I have a bit of old school programming under my belt.
I hope I named this right, but let me explain. An item is picked form a drop down list. That item has other data associated with it such as this:
A B C D E
THINGS DIFF. EASY AVERAGE HARD
Item1 Easy 0 1 3
Item2 Easy 1 3 8
Item3 Hard 2 5 13
Item4 Easy 4 8 18
Depending on what is in Col B, I would like to change the drop down list next to the first drop down list where you selected the item. So if I picked Item1, then the drop down list in the next cell would be of the EASY list. If I picked Item3, it would be from the HARD list... Etc.
Now I have not got started in VB stuff yet, and was hoping I could do it with the built in 2007 functions
Bookmarks