Krishnakumar
Well-known Member
- Joined
- Feb 28, 2003
- Messages
- 2,615
Hi All,
My orginal data looks like this (SAP generated)
And I need the result sheet like the following..
Any help would be appreciated!
My orginal data looks like this (SAP generated)
stock.xls | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | ||||||||||||
2 | Plant | 1011 | abc ltd | |||||||||
3 | Material | x1010001 | ||||||||||
4 | Description | item descr1 | ||||||||||
5 | ||||||||||||
6 | Stock on | 01.04.2005 | 2,974 | PC | ||||||||
7 | Receipts Total | 21,250 | PC | |||||||||
8 | Issues Total | 18,693 | PC | |||||||||
9 | Stock on | 05.04.2005 | 5,531 | PC | ||||||||
10 | ||||||||||||
11 | Plant | 1011 | abc ltd | |||||||||
12 | Material | x1010002 | ||||||||||
13 | Description | item descr2 | ||||||||||
14 | ||||||||||||
15 | Stock on | 01.04.2005 | 10,085 | PC | ||||||||
16 | Receipts Total | 62,880 | PC | |||||||||
17 | Issues Total | 38,400 | PC | |||||||||
18 | Stock on | 05.04.2005 | 34,565 | PC | ||||||||
19 | ||||||||||||
stock |
And I need the result sheet like the following..
stock.xls | ||||||||
---|---|---|---|---|---|---|---|---|
L | M | N | O | P | Q | |||
3 | Material | Description | Opng stock | Receipts Total | Issues Total | Clsg Stock | ||
4 | x1010001 | item descr1 | 2,974 | 21250 | 18693 | 5,531 | ||
5 | x1010002 | item descr2 | 10,085 | 62880 | 38400 | 34,565 | ||
6 | ||||||||
stock |
Any help would be appreciated!