Sorry,
Reposted to make more clear.

Khalil

"Khalil Handal" <khhandal@stthom.edu> wrote in message
news:O8$hy60SGHA.5156@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I have 13 worksheets (12 months, summary), for each month I have 1 column
> for item (B) and 1 column for codes for each item (EI). Item start at row
> 7.
>
> The item codes are: 100, 200, 300, . 900. Sub items have the codes like
> 710, 720 or 510, 520, not all of them have sub items code.
>
> Column C, D contains currency. See table below:
>
> A
> B
> C
> D
> EI
>
> Date
> Particulars
>
> Code
>
> 10/01/05
> Food
> 38.00
> 0.00
> 710
>
> 10/01/05
> Food
> 16.00
> 0.00
> 710
>
> 10/01/05
> Supply
> 50.00
> 0.00
> 800
>
> 10/01/05
> Books
> 48.00
> 20.00
> 710
>
> 10/01/05
> School Supply
> 812.00
> 0.00
> 820
>
> 01/01/05
> Equipment
> 156.00
> 0.00
> 500
>
> 10/01/05
> Garden
> 110.00
> 0.00
> 500
>
>
>
>
> The summary sheet looks like this:
>
>
>
> Code October November... all 2 months
>
> 710 (38+0+16+0+48+20)
>
> 200
>
> 210
>
> 220
>
> 500
>
> I need to lookup the codes and sum the amounts in column C and D for that
> item and put it in the row of October the line of 100. the same for the
> rest of the months.
>
>
>
> Note: the number of particulars differs from one month to another.
>
>
>
> Help is appreciated
>
>
>
> Khalil
>
>