Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Excel worksheets
I have 225 Excel files, each with one worksheet, all with exactly the same
colums and headings. Is there a way to combine all 225 worksheets into one long single worksheet? I need this to export to an Access table. I also have a workbook with 35 worksheets that should be combined into one worksheet, for the same reason. thanks, Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Excel worksheets
Hi Mike,
Ron de Bruin has sample code at: http://www.rondebruin.nl/tips.htm See, for example: http://www.rondebruin.nl/ado.htm http://www.rondebruin.nl/copy3.htm And, for your second task, see: http://www.rondebruin.nl/copy2.htm If you are not familiar with macros, you may wish to visit David McRitchie's 'Getting Started With Macros And User Defined Functions' at: http://www.mvps.org/dmcritchie/excel/getstarted.htm --- Regards, Norman "Mike" wrote in message ... I have 225 Excel files, each with one worksheet, all with exactly the same colums and headings. Is there a way to combine all 225 worksheets into one long single worksheet? I need this to export to an Access table. I also have a workbook with 35 worksheets that should be combined into one worksheet, for the same reason. thanks, Mike |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Excel worksheets
If you were to export your worksheets as CSV files into Access you would
save the effort of combining all your files just to export the data. Just an idea that may work! Regards. Bill Ridgeway Computer Solutions "Mike" wrote in message ... I have 225 Excel files, each with one worksheet, all with exactly the same colums and headings. Is there a way to combine all 225 worksheets into one long single worksheet? I need this to export to an Access table. I also have a workbook with 35 worksheets that should be combined into one worksheet, for the same reason. thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Overview Improvements for Excel Worksheets | Excel Discussion (Misc queries) | |||
How to Set background color XLM Excel worksheets in Netscape andFirefox browsers | Excel Discussion (Misc queries) | |||
Appending excel worksheets | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |