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

**JO505** · 01-15-2013, 04:15 PM

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

**djbomaha** · 01-15-2013, 11:20 PM

Hi Jim,

I posted some code below that copies the cells from column G to T whenever a cells in the range from G18:T43 is double-clicked per what I understood from your description. The worksheet is posted also so you can see how it works and if it is what you were looking for.

Please Login or Register  to view this content.

Thanks,

Daniel

**JO505** · 01-16-2013, 01:54 PM

Daniel,
Thanks for the response.

That is very close to what I am looking for but I am having a problem with the code. I pasted the code in my sheet and it almost works. By that I mean it will copy the format of the row but not the value. The section being copied is formated in a color and the data is displayed with formulas. The code copies the format but not the data. I dont care if the format is copied or not but it is the data I am trying to copy.

Also I will need to apply this to some other sheets in the workbook and I assume I can do so by adjusting the cell ranges as necessary.

Jim O