Hi

One way
1. On a new sheet, set up headings in A1:C1 of Heading, Amount and
Month.
2. Copy A2:Bnnn where nnn is the last row number from the sheet marked
April and paste to A2 of your new sheet.
Copy B1 from April, i.e. the Month name and paste to C2:Cnn so that the
Month name is alongside each entry.

Repeat procedure 2 for as many months as you have data, pasting the
entries immediately below those already entered.

On this new Master sheet create a named range by InsertNameDefine
Data
Refers to =OFFSET(&A&1,0,0,COUNTA($A:$A),3)

Then DataPivot TablesNextRange =DataFinish
Drag Heading to the Row area
Drag Month to the column area
Drag Amount to the Data area.

As you add more data each month, below the last entry ion your data
sheet, the range named Data will expand automatically to include this
new data, and clicking Refresh on the Pivot Table will incorporate it as
a new column.

For more help on Pivot tables take a look at the following sites
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html

http://www.datapigtechnologies.com/f...es/pivot1.html

http://www.edferrero.com/Tutorials.aspx

--
Regards

Roger Govier


"sajay" wrote in message
oups.com...
Dear Frinds,

Pls hlp
I have a situation where by i get only monthly trial balance like this
HEAD APRIL
HEAD 1 44,583.00
HEAD 2 1,405.00
HEAD 3 15,756.00
HEAD 4 17,099.31
HEAD 5 23,492.45

and next month
HEAD MAY
HEAD 1 11022
HEAD 2 545644
HEAD 3 345454
HEAD 4 154547

I want to arrange data like this
HEAD APRIL MAY
HEAD 1 44,583.00 11022
HEAD 2 1,405.00 545644
HEAD 3 15,756.00 345454
HEAD 4 17,099.31 154547
HEAD 5 23,492.45

I tried this
copied the April file to an excel sheet
copied the May file to another excel sheet
created a cloumn in may after the head column
copied the May sheet to April sheet
so it looked like this

HEAD APRIL MAY
HEAD 1 44,583.00
HEAD 2 1,405.00
HEAD 3 15,756.00
HEAD 4 17,099.31
HEAD 5 23,492.45
HEAD 1 11022
HEAD 2 545644
HEAD 3 345454
HEAD 4 154547

then sorted with head as key
but how to make amounts in a single row of months for head 1 etc. is a
real head ache
i have to cut paste and del
just for imformation i have almost 700 heads in one section and all
togather 4 subsectino
like general ledger and clients ledger and suppliers ledger and cash &
banks



is there any way to do this with out VBA?/
is there any way to do this with VBA