richiwatts
Board Regular
- Joined
- Aug 27, 2002
- Messages
- 131
I have a list on sheet 2 with 3 columns
Column A = ID
Column B = Name
Column C = Age
On sheet 1 I need to select the ID from a drop down list.
ID is in column A
Name is column D
Age is H
Is there a way that once I select the ID from the drop down list (list created from sheet) that I can automatically populate Name and Age in the correct columns/cells?
I hope this is understandable
Rich
Column A = ID
Column B = Name
Column C = Age
On sheet 1 I need to select the ID from a drop down list.
ID is in column A
Name is column D
Age is H
Is there a way that once I select the ID from the drop down list (list created from sheet) that I can automatically populate Name and Age in the correct columns/cells?
I hope this is understandable
Rich