Inserting a file in a work sheet in excel
Using Excel 2003
I want to combine a number of worksheets into one. Like you can i do with docs in Word to produce one document. Is there any other way of doing it rather than copy and paste? |
Inserting a file in a work sheet in excel
Open the target file and the source files and click on WINDOW, ARRANGE, TILED
to view all of the workbooks. You can then click on one of the source workbooks and click and drag the tab you want to your target. Don't resave the source workbooks as this actually moves the worksheet from the source file to your target. Or, activate one of the source files, right click on the tab you wish to copy and select MOVE OR COPY. From the list in th TO BOOK combo box, select your target. In the BEFORE SHEET list, select the position you want your copied worksheet to occupy in the target and check the CREATE COPY check box. -- Kevin Backmann "ST" wrote: Using Excel 2003 I want to combine a number of worksheets into one. Like you can i do with docs in Word to produce one document. Is there any other way of doing it rather than copy and paste? |
All times are GMT +1. The time now is 10:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com