I am new to this website and I am not familiar with macros.
I have a drop-down menu in Column A (labor categories), and drop-down menu in Column B (Region).
There are 20 labor categories in the Column A drop-down. There are 3 regions in the Column B drop-down.
In Column F (labor rate) I would like Excel to auto-populate the rate based on the Labor Category selected and the Region where the work will be performed.
How do I do this?
Thanks for your help!
I have a drop-down menu in Column A (labor categories), and drop-down menu in Column B (Region).
There are 20 labor categories in the Column A drop-down. There are 3 regions in the Column B drop-down.
In Column F (labor rate) I would like Excel to auto-populate the rate based on the Labor Category selected and the Region where the work will be performed.
How do I do this?
Thanks for your help!