M
mburr88
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!!
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!!