Auto populate with data validation

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?
 

Forum statistics

Threads
1,077,827
Messages
5,336,612
Members
399,092
Latest member
jbwatkins

Some videos you may like

This Week's Hot Topics

Top