Sheet 1:
Date Item
20/09/2006 abc
20/09/2006 abc
22/09/2006 xyz
22/09/2006 abc
26/09/2006 efg

Sheet 2:
item dept
abc Dept A
xyz Dept B
efg Dept A

Sheet 3:
Date Item Payout
20/09/2006 abc 100
22/09/2006 abc 110
23/09/2006 xyz 120
25/09/2006 abc 140
26/09/2006 efg 140
This is date wise item's payout.

Based on this data I need below mentioned detail

Date Dept A (total payout) Dept
B(total Payout)
20/09/2006
21/09/2006
22/09/2006
23/09/2006
24/09/2006
25/09/2006
26/09/2006

1) Look into sheet 1 and count how many time dept A or B is there
2) Multiply that no. with payout given in sheet 3. Here comes the realy
problem. Lets say if on 20/09/06 payout is 100 rs. for abc and payout changes
on 25/09/06 then from 20th to 24th payout will be 100 rs and it will change
on 25/09/06.
Suppose it is clear to you all. Please help.