Hi Alpha,

in sheet1, i have 3 columns with additional info that doesnt need to be copied over (to the right of all the dates in sheet1 (columns Q, R, S)).

However, running this macro will also copy these columns over, ruining some of the Sheet2 output and mismatching the results.

does this macro continue to the rightmost column? where can i edit the code to rule this out?

regards,

Sok