Magnus1on1
New Member
- Joined
- Oct 22, 2019
- Messages
- 1
Hi all, can't seem to figure out an issue.
I have data is cell A1 but want it to populate the next 2 cells only. Then the user will have to select data from a drop down list on the next cell following the 2 cells.
Example :
Colors: Green,Yellow,Red
Drop down selection: Free,Green,Yellow,Red
A1= Green (Select from drop down)
B1=Free (Autofill)
B2=Free (Autofill)
B3 = Yellow then the following cells do nothing.
B4= Red (Nothing happens to following cells)
At any given time a user can change the above cells using drop down list then the following cells would populate or do nothing.
Make sense?
I have data is cell A1 but want it to populate the next 2 cells only. Then the user will have to select data from a drop down list on the next cell following the 2 cells.
Example :
Colors: Green,Yellow,Red
Drop down selection: Free,Green,Yellow,Red
A1= Green (Select from drop down)
B1=Free (Autofill)
B2=Free (Autofill)
B3 = Yellow then the following cells do nothing.
B4= Red (Nothing happens to following cells)
At any given time a user can change the above cells using drop down list then the following cells would populate or do nothing.
Make sense?
