Is it possible to autofill a select box based on the previous column.
Column A has 3 selections, Design, Manufacture and Install. Based on what’s chosen, Column B will will show certain selections based on Column A.
Here is my selection process
Design - Design (1 Hour)
Installation - Installation (1 Hour)
Manufacture - Shop
Column A = Design, Column B will give the selection choice of just ‘Design (1 Hour)’. If Column A = Manufacture, Column B will give the selection choice of Shop, Vehicle, Window
Now this is easy enough to do but I’m fed up selecting Design (1 Hour) when there is only one choice, Can I autofill the selection box to just select the one result?