K
Khalil Handal
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
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