Hello,

I have a question regarding a pull down. I have two worksheets. In the fist
worksheet i have a pull down. In the second worksheet i have about 30 columns
that look like this

Column1 Column2 Column3 ...etc

Name1 Name2 Name3 ... etc
2 3 1
3 1 3
1 5 6
5 3 9
4 8 5
3 4 1
6 8 6
7 9 3
etc etc etc

What i would like to have is that if i select a name in the pull down
(sheet1) it receives the data of the whole column. So when i select name1,
the data under the pull down will be the same as the data that is under name1
in sheet2.

Hopefully i made clear what i want. Any help is appreciated

Thanks