Copy top line from list to another location HELP!!

[liamyoung]

Hello,

I have a range of data and I would like to be able to drill it down to one line and then have the information from that line copied to another location (in another sheet).

I'm ok with lists and being able to actualy filter the data. The complication arrises when I have drilled my data down to one row and i want to extract the data from THAT row only....

Any suggestions?......

Thanks

[liamyoung]

Example attached....