copy and paste from different sheets into one sheet using a VB code

[reena]

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

 

[Abdul Salam]

insert a new sheet at the beginning and do something like
this



Sub Copyarea()

For x = 2 To Application.Worksheets.Count
Worksheets(x).select
Range(Range("A1"),Range("A1").end(xldown)).select
selection.copy
sheet("Sheet1").select ' here will be all code
together
Range("A65536").end(xlup).offset(1,0).select
activesheet.paste
Next

End Sub

Abdul Salam

 

[Ron de Bruin]

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