Forum Discussion
Excel - Fill in values from column and row based on specific criteria to make list
Hi jacparks ,
If you share your spreadsheet these techie types will flock around here to flex their brains around it so fill it in with as much data samples as you can and post it on here because they like a good challenge puzzle to solve
cheers
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?
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
- 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.
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
- We would have to convert the drop down list into a searchable one so you can just type the first few characters i.e. Filler and it will narrow the selection down to 1 or 5 depending on what flowers you have that have that combination of spelling