Help Needed!! on inserting missing date within a col with new rows

[rej2k7]

Dear all ,

I need to format a report it, its of emp attentence;
there is thousads of lines, the given report shows only details of employees active day, no week days or absent days.

I need to fill this week days and other with just inserting missing dates / days between two rows.

the sample format is:
A B C
--------------------------------
4/4/2012
4/5/2012
4/8/2012
4/9/2012
4/10/2012
4/11/2012
4/12/2012
4/22/2012
4/23/2012
4/24/2012
4/26/2012
4/29/2012
4/30/2012
5/1/2012
5/3/2012
5/6/2012
5/7/2012
5/8/2012
5/10/2012
5/13/2012
5/14/2012
5/15/2012
5/16/2012
5/17/2012
5/20/2012
5/21/2012
5/22/2012
5/23/2012
5/24/2012
5/27/2012
5/28/2012
5/29/2012
5/30/2012
5/31/2012
6/3/2012
6/6/2012
6/7/2012
6/10/2012
6/11/2012
6/12/2012
6/13/2012
6/14/2012
6/17/2012
6/18/2012
8/28/2012
8/29/2012
9/2/2012
9/3/2012
9/4/2012
9/5/2012
9/6/2012
9/9/2012
9/10/2012
9/11/2012
9/12/2012
9/23/2012
9/24/2012
9/25/2012
9/26/2012
9/27/2012
9/30/2012
10/1/2012
10/2/2012
10/3/2012
10/7/2012
10/9/2012
10/10/2012
10/11/2012
10/14/2012
10/15/2012
10/16/2012
10/17/2012
10/23/2012
10/24/2012
11/8/2012
11/11/2012
11/12/2012
11/13/2012
11/14/2012
11/15/2012
11/18/2012
11/19/2012
11/20/2012
11/21/2012
11/22/2012


Cols B and C are not issues;
Just need to fill the gap between the dates with new rows;

Still searching old posts, but didnt get anything succ: yet;

Thanks in advance

Reji

[dilipandey]

Hi Reji,

Welcome to the forum.
Try using below code:-

Please Login or Register  to view this content.

Regards,
DILIPandey
<click on below * if this helps>

[rej2k7]

Showing Error type mismatch,
declared all variables, later the code run,
it inserted a single blank row, without any values,
debug: value is not transfering,
Cant get what and where it got blocked .... its long years since im out of this coding;

Help is highly appreciated;
Thanks Reji;

[xladept]

Hi rej2k7 and dilipandy,

I took the liberty of altering the dilipandey code - try it:

Please Login or Register  to view this content.

[rej2k7]

Once again; thanks all!!

[dilipandey]

Thanks xladept ..

Rej2k7, if your query is resolved, suggest you to mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey
<click on below * if this helps>

[xladept]

You're both welcome! Glad to have helped!