i cant figure it out.
I'd like to load a list based on the value of the cell above. for example:
In cell A1 you can choose Apples, Oranges or Lemons
if you choose Apples, the in cell B1 you get to choose from a list like: RED, GREEN, LARGE, SMALL etc etc
If you choose Oranges in A1 then you can choose ORANGE, JUICY, DRY etc etc in B1
And so on and so forth....
Any ideas???
Thanks!
I'd like to load a list based on the value of the cell above. for example:
In cell A1 you can choose Apples, Oranges or Lemons
if you choose Apples, the in cell B1 you get to choose from a list like: RED, GREEN, LARGE, SMALL etc etc
If you choose Oranges in A1 then you can choose ORANGE, JUICY, DRY etc etc in B1
And so on and so forth....
Any ideas???
Thanks!