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