Excel

This query is : Resolved

C A tejal (Querist)
Follow

22 May 2010 I have prepared sheet for the stock of 20 items in the following formate:

Oct. Item 1 Item 2
Day
Ope Pur Sale Cl
1 6.70 13.15 6.70 13.15
2 13.15 0.00 13.15 0.00
3 0.00 13.35 0.00 13.35
4 13.35 6.50 13.35 6.50
5 6.50 19.70 6.50 19.70
6 19.70 19.75 19.70 19.75
7 19.75 6.65 19.75 6.65
8 6.65 13.50 6.65 13.50
9 13.50 13.40 13.50 13.40
10 13.40 13.35 13.40 13.35
11 13.35 33.30 13.35 33.30
12 33.30 136.50 33.30 136.50
13 136.50 96.15 15.15 217.50
14 217.50 159.15 12.20 364.45
15 364.45 19.95 380.40 4.00
16 4.00 13.60 4.20 13.40
17 13.40 0.00 5.00 8.40
18 8.40 0.00 3.00 5.40
19 5.40 0.00 3.00 2.40
20 2.40 0.00 2.00 0.40
21 0.40 6.75 3.00 4.15
22 4.15 0.00 3.00 1.15
23 1.15 25.45 20.00 6.60
24 6.60 13.35 15.00 4.95
25 4.95 6.80 10.00 1.75
26 1.75 13.35 15.00 0.10
27 0.10 13.00 12.50 0.60
28 0.60 13.20 10.00 3.80
29 3.80 13.10 15.00 1.90
30 1.90 6.70 5.00 3.60
31 3.60 13.45 15.00 2.05

I have prepared such 12 excel sheets each saperat sheet for 12 months and each include total 20 Items, above data is a part of a sheet for an example.
Now as per my requirement I want month wise sheet in following format:
Total 31 days and 20 Items
Purchase 1 2 3 4
Itme 1 13.15 0.00 13.35 6.50
Item 2 6.50 20.00 26.20 19.95
Item 3 5.70 0.00 5.85 0.00
Item 4 0.00 0.00 6.00 0.00
And so on

Is there any Excel formula by which I can get result like this?
Please friend help me its very very crucial.
Thanks in advance.

Ram Avtar Singh

Ram Avtar Singh (Expert)
Follow

22 May 2010 submit your quary in forum section to under stand better you requirment.

of attached file so your matter will be short out.

Message likes : 1 times

C A tejal

C A tejal (Querist)
Follow

22 May 2010 Thanks for the instant reply..
I have posted in forum section..

Upgrade to CAclubindia Pro. Subscribe Now!

CA. Dashrath Maheshwari

CA. Dashrath Maheshwari (Expert)
Follow

24 May 2010 Solution is Pivot Table, which I have sent to your mailbox

Message likes : 1 times

CA. Dashrath Maheshwari

CA. Dashrath Maheshwari (Expert)
Follow

02 June 2010 Other members can see the solution attached at 2nd reply to page two of :
https://www.caclubindia.com/forum/require-excel-function-which-can-solve-my-query-84321.asp?offset=2