Hi,

I have 2 column of data in sheet 1. Column A is date and B is value. I
want the value in column B sheet 1 to copy column B sheet 2 according
to date.

SHEET1
A B
27/01/2010 230
31/01/2010 110
03/02/2010 34
11/02/2010 10
18/02/2010 5
12/02/2010 78
20/02/2010 22
27/02/2010 78


SHEET 2

A B
01/01/2010
02/01/2010
03/01/2010
04/01/2010
05/01/2010
06/01/2010
07/01/2010
08/01/2010
09/01/2010
10/01/2010
11/01/2010
12/01/2010
13/01/2010
14/01/2010
15/01/2010
16/01/2010
17/01/2010
18/01/2010
19/01/2010
20/01/2010
21/01/2010
22/01/2010
23/01/2010
24/01/2010
25/01/2010
26/01/2010
27/01/2010
28/01/2010
29/01/2010
30/01/2010
31/01/2010
01/02/2010
02/02/2010
03/02/2010
04/02/2010
05/02/2010
06/02/2010
07/02/2010
08/02/2010
09/02/2010
10/02/2010
11/02/2010
12/02/2010
13/02/2010
14/02/2010
15/02/2010
16/02/2010
17/02/2010
18/02/2010
19/02/2010
20/02/2010
21/02/2010
22/02/2010
23/02/2010
24/02/2010
25/02/2010
26/02/2010
27/02/2010
28/02/2010

What is the formula that i should use?

Thank you

dave
United Kingdom