Import File

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have office 2003 excel. There is no "Import File" commands in any of
the menus. Is that normal or do I have something set up wrong?

I have open workbook. Click on blank sheet 2. Then I want to import
another excel sheet from another workbook.

John
 
Open the other workbook

The on each sheet you need in the 2nd book, right clik on the sheet tab
And this will let you move or copy each sheet to whereever you want in the
first one.

Steve
 
John

You will find the "Import" on the Data menu.

Data>Import External Data.


Gord Dibben MS Excel MVP
 
You can also just open up both workbooks, tile them so you can see them both
and then just click on the tab and drag it from one to the other. Hold down
CTRL whilst doing it to copy, or don't and it will move it.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
Back
Top