Inserting a file in a work sheet in excel

S

ST

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?
 
K

Kevin B

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.
 
Top