See this example page Reena
http://www.rondebruin.nl/copy2.htm


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"reena" wrote in message ...
hi

I have a budget file with me.format of each sheet is as
follows


Gl code Budget Oct Nov DEC JAN...........SEPT
Total
0101120222 1200 100 100 100 100 ...........



total 20 Sheets in each file .I want to import this into
accounting Package for that purpose i need to copy all
these codes into one sheet and prepare a trail balance
monthwise.
how can i do this?
Your help is greatly appreciated

Thanks
rc