Edit Macro to Copy and Paste Data from another sheet according to date

Hi everyone,

I have problem with a code i use, it is attached in the sample file.

Sample.xlsm

What it is supposed to do is check the latest dated data in sheet1, then go to sheet2, copy entire columns with dates only later than in sheet1, loop until end of data in sheet2. Currently it does not work, im not sure which part of the code is wrong.

Please Login or Register  to view this content.

Please help out, thanks.

Solved it already.

Here's the code if anyones interested, this code was edited from the one Nilem gave me before.

Please Login or Register  to view this content.