Forum Discussion

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...

Ordering Spreadsheet WORKING JUNE 21.xlsx37 KB

excel

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

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

jacparks

Copper Contributor

Jun 28, 2021

Do you think the Ingredient list on the left is causing me problems and I can just do the data validation lists right across the top of the page? Would that be any better? That would change all of my other formatting and formulas though.

Yea_So
Bronze Contributor
Jun 28, 2021
Hi jacparks,

The ingredients list is functional to the entire scheme of things, especially when you will be sitting with a client during the selection. Why don't you take a look at this workbook.

In the ingredients list, if you put a space character on the cell adjacent to the drop down, it will change the drop down menu to the Ingredients header, and when you make a selection will format the header with its appropriate highlighting, and on top it will display the ingredient header in bold. Let me know your thoughts.

cheers

Ordering Spreadsheet WORKING JUNE 21.xlsx40 KB
- jacparks
  Copper Contributor
  Jun 29, 2021
  Yep perfect that's great!