Macro to Copy Coloured Data on "Import Templates last updated" created by CF

I have the following Code below to copy data that is coloured in Cols A1 to last row in Col D on sheets "Import Templates last updated" created by CF
and paste these on sheets "Reports Ready for checking"


When running the code, the data in the last row in Col D and E is being removed

Kindly test and amend my code that this does not happen

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks Jindon

Your solution works 100%

Thanks kvsrinivasamurthy

Your solution works perfectly