Copy Paste data last row missing

Hi All,

I want copy the daily data to daily result sheet, but when i run macro the last row is missing. What i am doing wrong?
Also i need the add a column to daily result sheet with running balance of debit and credit column.

Thanks!

no, it won't work

Your code, change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

I would write like this

Please Login or Register  to view this content.

Thank you, both code works perfect!

jindon
Instead of my code i want now use your code can you do me a favor.
In result sheet column A some dates cannot convert using DateSerial method as result it shows "00:00:00 AM".
Instead of this "00:00:00 AM" can you fill the cell above date.

try change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Perfect, worked great!

Thank you torachan & jindon, that solved my problem.