How do I populate an entire row by choosing one cell from a list
I need to create a spreadsheet template that is used multiple times daily.
The list source is on one worksheet and the template is on the other sheet.
I want to be able to choose one value in the list, and have the adjacent
cells in the cell's source list row automatically populate on the template.
for example:
Source List:
NAME AGE HEIGHT WEIGHT
jones 27 72' 210lbs
smith 32 68' 185lbs
On the template page, I would like to be able to choose the name "jones",
and have the age, height, and weight automatically populate on the template.
Thanks in advance for your assistance.
|