Marco that check date and look up column

[imag1ne]

Hello.
I'm new here and come here with first problem.
I need to make macro (I think it will be macro, maybe formula, not such a expert) that checks date in one cell, then reads data from column in same sheet. After that find column in different sheet with same date and copys data in there.
Something like this.

Sheet1

	A	B	C	D	E
1	Description	Size	02/05/2013	07/05/2013	12/05/2013
2	Box	100
3	Tape	50
4	Paper	2000
5	Kit	1

Sheet2

	A	B	C	D	E	F
1	Description	Size	Count		Date	12/05/2013
2	Box	100	83
3	Tape	50	24
4	Paper	2000	6
5	Kit	1	128

So I need that it checks the date in sheet2 (F1) then finds a column in sheet1 with the same date and copys all date from column (C2:C5) in sheet2 to matching date column in sheet1.

[AlphaFrog]

Hi and welcome. Try something like this...

Please Login or Register  to view this content.

[imag1ne]

Works like a charm. U are master-blaster! Thank You, u saved my ***.