Double click to copy and paste value to first available row.

I need to be able to copy data from a range "G18:T43" and then by double clicking on a row, copy the data only to a target range, rows "G9:G15" on a first available blank row basis. I hope this is clear enough, if not let me know and I will try to be more specific.


Thanks

Jim O