|
NEND | I never could make a dependent drop-down list box. Here is a tutorial on how to make it happen, but I wasn't ever able to totally incorporate it in spreadsheets I've attempted to. If you can make it work, I'd love to see it. My tip is, just start typing the input and you will see the input show up
http://www.contextures.com/xlDataVal02.html
Also, I see you inserted a column in the main table (on the New Method tab). I would have thought the formulas in the other columns would have automatically updated. They aren't correct now, you need to increase the number of the lookup column by one in every column that uses that formula (I think there's three of them). If you change one of the formulas, all the rest in that column will change. | |
|