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?
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Watch MrExcel Video

Forum statistics

Threads
1,089,979
Messages
5,411,640
Members
403,383
Latest member
Excelacity

This Week's Hot Topics

Top