Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    import one SS into another (2003)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: import one SS into another (2003)

    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.

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: import one SS into another (2003)

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •