Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste from different sheets into one sheet using a VB code
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste from different sheets into one sheet using a VB code
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 -----Original 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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste from different sheets into one sheet using a VB code
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy and paste using vb code | Excel Discussion (Misc queries) | |||
copy and paste formula using vb code | Excel Discussion (Misc queries) | |||
Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
copy from one sheet and paste into other sheets | Excel Discussion (Misc queries) | |||
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions |