I'm not sure if what I'm trying to do is even possible, but if anyone could
figure out how to do it, that would be great!
Here's what I want to happen: I want one column (say, B) to have a drop-down
list of things, say W, X, Y, Z. Then, when you choose an option, say W, I
want pre-set values to appear in columns C, D, E, etc.
For example, if you pick W in the drop-down list in column B, then in column
C, the number 1 would appear, and in D, 2, E, 3, etc. (So it would look like:
W 1 2 3 ...)
Or if you pick X, it might be: X 5 6 7 ....
Y might be: Y 3 7 2 ....
etc

Is it possible to make this happen? If so, how??? In the simplest terms,
please :)
Thank you so much!!