Hi Forum!
I am making a daily production sheet in EXCEL2002 and need to have a list in one column that allows a user to select one of, say, 15 product types from a drop down menu (I know how to make this using Data Validation) for each hour of a shift, and then output into an adjacent cell a standard associated data value.
Because I want more than 7 options, I cannot do this using "IF" loops and am pretty sure I need to make a pivot table or VBA coding, but I am very green to these tools.
Example of what I want:
Product Options (A-O) in drop box for each cell in Column A
Each product (A-O) will have associated static value automatically output to Column B, such as: A-> 35, B-> 37, C-> 31, D-> 42, etc.
Please give me an example or reference to guide me or some kind of direction.
Thank you in advance,
Derek
I am making a daily production sheet in EXCEL2002 and need to have a list in one column that allows a user to select one of, say, 15 product types from a drop down menu (I know how to make this using Data Validation) for each hour of a shift, and then output into an adjacent cell a standard associated data value.
Because I want more than 7 options, I cannot do this using "IF" loops and am pretty sure I need to make a pivot table or VBA coding, but I am very green to these tools.
Example of what I want:
Product Options (A-O) in drop box for each cell in Column A
Each product (A-O) will have associated static value automatically output to Column B, such as: A-> 35, B-> 37, C-> 31, D-> 42, etc.
Please give me an example or reference to guide me or some kind of direction.
Thank you in advance,
Derek
