Copy data from worksheet row and populate cells in worksheet 2

[nutterino]

Hi,

Please could someone help.

I'm trying to copy specific data from a row in worksheet 1 to specific cells in worksheet 2 by pressing the "Generate Invoice" button.

When I add a new row of data to worksheet 1 "Timesheet" I need to take the data from columns A, I, J, L & M and copy to cells B24, E24, H25, C25 & O10 into worksheet 2 "Invoice".

I've tried recording a macro but can't get it to work exactly

Thanks, Paul

Please find file attached.

[ravishankar]

Hi
try the macro in the attached file.merged cells are incompatible with this macro. Undo them. Check if the destination cells are spelt correctly. Run the macro
Ravi

[nutterino]

Thanks Ravi

Macro works great

Paul