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

[Howardc1001]

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.

[kvsrinivasamurthy]

Try
Code:

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

[Howardc1001]

Thanks Jindon

Your solution works 100%

[Howardc1001]

Thanks kvsrinivasamurthy

Your solution works perfectly