Hi ,

SORRY ABOUT FORMATTING THIS IS MY FIRST POST.

i have 3 Sheets;
Sheet1 is for data input it contains 3 Columns :Name | Description| Type <--------- is a drop down list, which is populated from the column headers in sheet 2
Sheet 2 contains a table with data. It is structured like this;
Boy| Girl <------Column Headers
eye colour
height
weight
hair colour
^
Attributes

Sheet3 Is the output sheet its combine the columns from sheet 1 and the attributes in sheet 3, The columns would look like this ;

Name |Description| Eye Colour| Height| Weight| Hair Colour

Scenario:
User enters on sheet1 Bob , arts, Boy . I would then like for Sheet 3 to populate with ;

Name|Description| Eye Colour|Height|Weight|Hair Colour
Bob Arts ..... ...... ..... .........

So what ever options was picked in the dropdown list it would get those attributes(from Sheet2) and display in the correct columns( in Sheet 3)

Thanks