sajay.

You could do this with a pivot table:

With each months data in a separate sheet select Data Pivot Table Report
Multiple Consolidation Ranges Next I will create the page fields Next

In the 'Step 2b of 4' dialog box click into the 'Range' box to activate it
then highlight the range in the first sheet, click the Add button then
repeat the process until you have all the sheets ranges in the "All Ranges"
box. Leave the "How many page fields do you want?" selected at zero. Then
select Next

If the box in the Data fiels is saying "Count of data" double click on it
and select "Sum" in the PivotTable Field dialog box then select OK and then
Next.

In Step 4 select New worksheet or existing worksheet as you require. then
select Finish.

If you are adding more months later then select any cell in the pivot table
with a right-click and then select Wizard. Go back to Step 2b and add the
new data range as before. If you are updating the existing Pivot table then
make sure that you select both the sheet and upper left-hand cell of the
existing pivot Table.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"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