| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining files to one workbook
Excel 2002
I have several related files that need to be in 1 workbook. Is there an easier way than adding new worksheets, copy/paste the other workbooks and renaming each new worksheet? This seems to be a repetative task that is right up Excels alley. Anyone?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining files to one workbook
See Ron de Bruin's site
http://www.rondebruin.nl/tips.htm Browse through the section on Copy/Paste/Merge examples Gord Dibben MS Excel MVP On Tue, 20 Mar 2007 13:06:08 -0700, toneman wrote: Excel 2002 I have several related files that need to be in 1 workbook. Is there an easier way than adding new worksheets, copy/paste the other workbooks and renaming each new worksheet? This seems to be a repetative task that is right up Excels alley. Anyone?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Two Files | Excel Worksheet Functions | |||
| Combining Excel files - Please help! | Excel Discussion (Misc queries) | |||
| combining excel files | Excel Discussion (Misc queries) | |||
| combining files | New Users to Excel | |||
| Macro Help- combining "CS" files | Excel Discussion (Misc queries) | |||
Linear Mode
