+ Reply to Thread
Results 1 to 3 of 3

merging excel files

  1. #1
    Registered User
    Join Date
    06-08-2005
    Posts
    2

    Post merging excel files

    I have two excel files one where there is already information about budgets with headings and figures and a file that has just the labels...im trying to make it so when i input the numbers from one file that they automatically are filled in the correct cells in the other file...is this possible? I understand you can do this from one sheet to another using a formula but im not sure if you can do it from file to file...any help would be appreciated thanks.

  2. #2

    Re: merging excel files

    You can do this file to file. If you open both workbooks, then just
    link to the appropriate cells by typing "=" and then selecting the
    other workbook and clicking on the appropriate cell, press enter to
    finish and you're done.

    The name in the formulae bar will show the workbook name you are
    linking to. If you then close the source file, the name in the formulae
    bar will also include the full path to the closed spreadsheet. You will
    be asked if you want to update links when you open the spreadsheet
    containing cells with links.


  3. #3
    Registered User
    Join Date
    06-08-2005
    Posts
    2
    Thanks stevie i appreciate your help very much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1