right click on the tab of the sheet with the data, select view code, thenput
in data like this:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Set rng = Workbooks("Mybook2.xls") _
.Worksheets("Sheet1").Cells(Rows.Count, 1).End(xlUp)(2)
Target.EntireRow.Copy rng
Cancel = True
End Sub

The challenge is how to communicate which workbook/cell to copy the
information to.

You haven't provided enough information to determine that.

--
Regards,
Tom Ogilvy

"Alan M" wrote in message
...
I have one workbook sheet with a price list and associated dat in rows. I
need to be able to double click or similar on a cell containeing the pirce
of
a particular model have this action select all the associated data in that
row and enter this detail in a series of cells in another
workbook/worksheet.

Any suggestions on how to code this please?