sorry i didn't know how else to title it. tried searching for autofill on the forum but it wasn't what i'm trying to solve.
i have a drop down list (data validation) of names. the names are in column A, and there are 3 name types (position, cell, email) on columns B, C, and D.
i'm trying to have the user select a name from a drop list, then autofill the corresponding name types.
A B C D
(name) (position) (cell) (email)
john president 12 abc
dave accounting 34 def
steve operation 56 ghi
select name: john
position: autofill B
cell: autofill C
email: autofill D
**so the user selects "john", and below, autofill B, autofill C, and autofill D
any help is appreciated!
i've attached a file
Bookmarks