EXCEL: Importing table data from xls file to other xls file!?

Discussion in 'Mac Apps and Mac App Store' started by Fallinangel, Jan 3, 2009.

  1. Fallinangel macrumors regular

    Fallinangel

    Joined:
    Dec 21, 2005
    #1
    It it possible to import table data from one Excel file dynamically into another Excel file?
    If yes how?

    Thank you!
     
  2. exegete77 macrumors 6502a

    Joined:
    Feb 12, 2008
    #2
    Howdy. When you write "dynamically" do you mean that a change in the original is automatically made in the new worksheet?
     
  3. Fallinangel thread starter macrumors regular

    Fallinangel

    Joined:
    Dec 21, 2005
  4. exegete77 macrumors 6502a

    Joined:
    Feb 12, 2008
    #4
    It can be done with formulas, but will require that you not change the location of the files, because you need the path constant. Also, depending on the kind of data you need, you might have to experiment a little.

    For instance, you can open both books, and in the target workbook, enter = in the desired cell, then click on the other workbook and the appropriate cell. That should get you started. I don't have Excel any more, but had worked with it every day for 8 years until this year.
     
  5. Ramashalanka macrumors regular

    Joined:
    Dec 26, 2008
    Location:
    Lanka Ravi Shanka
    #5
    Or, if you don't want to click, you can type in eg

    ='[first.xlsx]Sheet1'!$E$29

    in the new worksheet. Is that what you want?
     

Share This Page