Inserting Data on Linked Spreadsheet

[Carl Clements]

Hi,

I have some 'BeforeDoubleClick' code that opens a separate spreadsheet template when I double click on a cell. Next, I would like some of the data on the row that I double click, to populate on the spreadsheet template that opens. The information on both spreadsheets will always come from and go to the same cells on it's respective spreadsheet.

For this to work, I understand I need the code in a module that first Calls the 'BeforeDoubleClick' code. However, I'm not sure how I would begin linking the data between spreadsheets. Can anybody help?

Thanks,
Carl