View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jumpmaster_france jumpmaster_france is offline
external usenet poster
 
Posts: 1
Default 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.