Select Row and auto fill cells in another worksheet

Hi,

I'm looking for a way for a user to select a row of data in WS ONE, either by a radio button in the first cell of that row, or other means, and have the info from that row fill specific cells in WS TWO. I've included a spreadsheet with mock info and the cells i would like to copy over to WS TWO.

Thank you,
Mike

duplicate post: http://www.excelforum.com/excel-prog...rksheet-_.html