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?? |
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?? |
All times are GMT +1. The time now is 08:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com