VBA Help required to speed up the code

[motherindia]

Hi Mick Sir,

Thanks for provding the very beautiful piece of code.

http://www.mrexcel.com/forum/excel-...-end-date-range-between-2-sheets-each-id.html


I tried the above with real data. The sheet contains 2-3 lakh rows in 2 sheets. The code was running for 2 hrs and still running.

Is there way to speed up this.
please help me

Regards,
mother india

 

[motherindia]

Hi Oeldere,

if you are asking number of days into each row, then row count would be 8 -9 lakh rows.

without splitting date ranges 1-2 lakh.

Reagrds,
motherindia

 

[motherindia]

Hi Kalak,
Thanks a ton for providing piece of codes. It works at amazing speed.
Your code check for the exact match of start date and end date against each id. However I want to compare each day between date ranges from sheet1 with date range of sheet2 and provide only mismatch on 3rd Sheet.

In my example given above ;
Sheet1 for E# 9820559

9820559 21-Aug-15 22-Aug-15 1.50 NW
In Sheet2 for E# 9820559

9820559 21-Aug-15 21-Aug-15 1.00 NW

Here the mis match is only for 22nd Aug and for half day and 21st Aug is matching in both sheet.
Hence the result should be;

9820559 22-Aug-15 22-Aug-15 0.5 Not in Shee2 and not like below;

9820559 21-Aug-15 21-Aug-15 1 NW not in sheet1
9820559 21-Aug-15 22-Aug-15 1.5 NW Not in sheet2







Regards,
motherindia.

 

[motherindia]

Hi Sir,

Anyone on the board can please help me out.

Regards,
motherindia.