K
Kelly
I have three lists in my worksheet, one of which is the reference list for a
drop down in column A. I want to write a code that, when an item is selected
from the drop down in column A, the corresponding selection is found in the
reference list and the values in the lists on either side are returned to
autofill cells in columns B and C. Example:
Column A Column B Column C (list 1) (list 2 - ref)(list 3)
100714 (auto fill from lists) ERP 100714 brake
(drop Down) EDC 100715 Can
MIP 100716 Tank
Can anyone tell me how to do this?
drop down in column A. I want to write a code that, when an item is selected
from the drop down in column A, the corresponding selection is found in the
reference list and the values in the lists on either side are returned to
autofill cells in columns B and C. Example:
Column A Column B Column C (list 1) (list 2 - ref)(list 3)
100714 (auto fill from lists) ERP 100714 brake
(drop Down) EDC 100715 Can
MIP 100716 Tank
Can anyone tell me how to do this?