Forum Discussion

jacparks's avatar
jacparks
Copper Contributor
Jun 21, 2021
Solved

Excel - Fill in values from column and row based on specific criteria to make list

Hi!    I am a florist and I make a spreadsheet with the item that I am building (Ex. Bouquet), I specify the flowers I am using at the top then I fill to the right with the number of stems I want i...
excel
  • Yea_So's avatar
    Yea_So
    Jun 23, 2021

    jacparks 

     

    Here's a video to make your drop down list a searchable one, you type the first few characters then click on the drop down and will narrow your selection to the appropriate selections:

    https://youtu.be/Ea_ACp5W8zI

jacparks's avatar
jacparks
Copper Contributor
Jun 28, 2021

Yea_So Ok, can I pick your brain some more.  

On the FLOWER sheet, is there a way that if there are blanks in the ingredients list that it skips to the next cell that has a vale when it fills in the J1:AC1?

 

Yea_So's avatar
Yea_So
Bronze Contributor
Jun 28, 2021

Hi jacparks,

 

We can get creative.  I was thinking that we can include the Ingredient Headers as part of the drop down selection, and once they're selected we can have excel do a conditional formatting to the headers then it'll only skip 1 column at each indgredient header.  What are your thoughts about it.

 

cheers

Resources