Hi,
I'm trying to autofill a column in excel, after having chosen values in two different columns from drop down lists. Basically it's a product code that I want to autofill itself in a column after a unit size and blend description is chosen, from two drop down lists in two other columns. Every blend + size = a unique product code.
Any tips on how I can easily do this?
I currently have one of the drop down lists on a different sheet (marked lists) and one the other one I simply made straight from the data validation as it was short.
The yellow square is where I want the autofill, based on the two values in the red squares.
Thanks!
I'm trying to autofill a column in excel, after having chosen values in two different columns from drop down lists. Basically it's a product code that I want to autofill itself in a column after a unit size and blend description is chosen, from two drop down lists in two other columns. Every blend + size = a unique product code.
Any tips on how I can easily do this?
I currently have one of the drop down lists on a different sheet (marked lists) and one the other one I simply made straight from the data validation as it was short.
The yellow square is where I want the autofill, based on the two values in the red squares.
Thanks!