I want to copy cells “A” to “K” from the last row of the worksheet “Payments received” to the next available row of the “Reports”-workbook’s worksheet “Record of payments”, only when I save “Payments received”. The columns of “Record of payments” are identical to the columns of the worksheet “Payments received”. I managed to copy the entire last row or only range “A” as soon as data is entered. All my attempts to copy A to K before save end in a yellow highlighted code!

I will really appreciate your help.