import one SS into another (2003)

Topic

New Reply

Is there a rational method to open open an Excel spreadsheet sheet into another file? I mean like a “File.. Import.. Into current sheet” command?

I’m having to open each file I want to use, and copy and paste them. Making a new sheet first, and then moving it because Excel puts it in a dumb order, and then rename it, and then copy it, and then paste it, and then maybe do that more than once if you weren’t perfect, and then deal with the clipboard error message which you have to read every single time since it has about 5x too many words, and the dialog box is upside down from the “standard” way of doing things, etc. etc. etc. etc. etc.

I looked at “Merge workbooks” but that’s an even madder rabbithole to go down. I quit after the 4th consecutive “You haven’t set up so-and-so correctly yet.” message.

Thanks for any ideas.
Jim Helfer

Reply | Quote

Replies

If you open both the source and the target workbook, you can move or copy an entire worksheet in several ways:

1. Activate the source worksheet, then select Edit | Move or Copy Sheet… (also available when right-clicking the sheet tab.) You can specify the workbook to move/copy the sheet to, and where to place the worksheet.

or

2. Select Window | Arrange… to tile the workbooks. You can drag (to move) or Ctrl-drag (to copy) the source worksheet to the target workbook; drop it in the position where you want it.

Reply | Quote

In addition to Hans’ suggestions, you could look at the following Menu items :

Data,
Import External Data
Import Data

and in the Select Data Source dialog, browse to and select the file with the data you wish to import. You should then be able to select which sheet to import and which starting cell to import the data to.

Andrew C.

Reply | Quote

In addition to Hans’ suggestions, you could look at the following Menu items :

Data,
Import External Data
Import Data

and in the Select Data Source dialog, browse to and select the file with the data you wish to import. You should then be able to select which sheet to import and which starting cell to import the data to.

Andrew C.

Reply | Quote