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 :-)
------------------------------­------------------------------­----------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top