Active Cell Copy and Paste

Hello All,

Please refer to attached file...

I need a VBA code that will copy specific cells from Sheet1 (based on active cell selected), and paste them to specific cells on Sheet2. So, If I was to select any of the cells in columns H through S on Sheet1, it would copy that cell, and would also always include cells A, C, and F from the same row. Then paste: cell A from Sheet1 to Sheet2 cell A5; cell C from Sheet1 to Sheet2 cell B7; cell F from Sheet1 to Sheet2 cell D7; and whatever active cell from (H through S) Sheet1 to Sheet2 cell A9.

Please let me know if you have any questions.

Thanks,
darias

Hi, Holger,

Code works perfectly... Thank you very much!

Regards,
darias