copy certain cells in target row to bottom of list

Hi, I need a bit of help, need code when I click on a cell, then certain cells in the target row are copied and pasted to the bottom of a list and yes, this has merged cells, sorry. So in the screenshot, if you click on the yellow cell I want the green cells copied to the bottom of the list. I have also attached a sample workbook. Thanks.Copy_bottom.PNG

Awesome bakerman2! Thanks a lot!!

Ok, I've got it working, but I also want to copy the cell in column AB, which was working and now isn't. Anyone?

Please Login or Register  to view this content.

Thanks for the clarification bakerman2. I want to copy the cell in column AB to the same line as where the other cells B:O are being copied to, so I want B:O & AB in this case.

Slept on the problem and figured it out this morning!

Please Login or Register  to view this content.

Thanks again bakerman2!

I am puzzled, in the example workbook I provided here (multiple_hose2) cell A29 which is a large merged cell is empty as it contains sensitive information. The code bakerman2 provided works great in the example workbook, but when I add the data back into A29, it doesn't work. Can someone explain why this is the case and is there a way to make it work? Thanks.

I think I know what the problem is, in the example provide here, none of the cells in the form have formulas, whereas in my working sheet, there is formulas in 90% of the cells. Is there a way to make it work because of this?