Copy and Paste values in a named range using Data validation drop down list.

[peterinaudo]

Hi every one, would appreciate some help with this problem if you have any ideas-

I am using Excel 2007 on Vista operating system.

I have created a Data Validation drop down list of named ranges (single columns of data approximately 6000 rows ) in Sheet1 and placed this dropdown list in Sheet2. <o></o>
When I select a name from the list I would like all of the values (Values only, not formulas) in that named range in Sheet1to be pasted in the cells below the drop down button in Sheet2.<o></o>


thanks.