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 24, 2021
Oh my gosh you're the best! it's perfect thank you so much!
Yea_So's avatar
Yea_So
Bronze Contributor
Jun 24, 2021

Hi jacparks,

 

I'm happy to help.

 

cheers

Resources