Hi,

I have data in worksheet which has 2 columns of dates and rates. I need
to populate the missing dates and rates with the rate just prior to the
missing date.

Ex:

3/27/2002 0.0522
3/28/2002 0.0529
4/1/2002 0.0529

The above data has 3/29/2002, 3/30/2002 and 3/31/2002 missing. I would
have to add these dates and populate the rate with the rate of
3/28/2002 (which would be 0.0529).

I need to do this for 20,000+ records. I am new to excel. Is there a
way to do this using a macro/VB script?

Thanks,
Pamarty