Value entered automatically on lookup of date in column

[junoon]

Hi,,

Could anyone help me with a query i have??




A B C D
E F
----------------------------------------------------------------------------------------------
HC Date Mdates Added
----------------------------------------------------------------------------------------------
17 19-Jun-06 01-Jun-06 17
02-Jun-06 17
03-Jun-06 17
04-Jun-06 17
05-Jun-06 17
06-Jun-06 17
07-Jun-06 17
08-Jun-06 17
09-Jun-06 17
10-Jun-06 17
11-Jun-06 17
20 30-Jun-06 12-Jun-06 17
20
13-Jun-06 17
20
14-Jun-06 17
20
15-Jun-06 17
20
16-Jun-06 17
20
17-Jun-06 17
20
18-Jun-06 17
20
19-Jun-06 17
20
20-Jun-06
20
21-Jun-06
20
22-Jun-06
20
23-Jun-06
20
24-Jun-06
20
25-Jun-06
20
26-Jun-06
20
27-Jun-06
20
28-Jun-06
20
29-Jun-06
20
30-Jun-06
20

If i enter a Date in Column B (which is a date from Column C), the
points given in Column A should automatically show in Column D, till
that date reflecting in Column C. I again i enter a date in Column B
down, the corresponding point should reflect in the next column after
Column D (i.e. Column E), till that date showing in Column C.


Could anyone please help me with this????

Warm Regards,

Junoon