Hi to all

here is the problem I am having

I have coped a lot of codes from the web but I can not get them to work for me. This is due to me being a novice at vba and do not understand the code.

I am trying to get up together a vba code to double click on a cell 2 in column D in a table to copy from sheet 7 to sheet 3 in merged cell C23 to Y23
at the same time cell 2 column E from sheet 7 to sheet 3 in merged cell AD24 to AG24 for this bit I need the cell value not the formula.

when I repeat the above in needs to go in the next line down in sheet 3

Thank you

Ian