+ Reply to Thread
Results 1 to 3 of 3

link cell content to another file

  1. #1
    blackstar
    Guest

    link cell content to another file

    how would i go about linking a word from one excel doc to another.
    ex: cell A2 in document 1 has the word "dog". i want cell A2 in document 2
    to show the same word by linking the files together.

  2. #2
    Andrew
    Guest

    RE: link cell content to another file

    Easy, be in cell A2 in document 2 and then press '=' and click on 'Window'
    (in menu bar), selected document 1, click on cell A2 and press 'Enter'..
    --
    Andrew


    "blackstar" wrote:

    > how would i go about linking a word from one excel doc to another.
    > ex: cell A2 in document 1 has the word "dog". i want cell A2 in document 2
    > to show the same word by linking the files together.


  3. #3
    blackstar
    Guest

    RE: link cell content to another file

    thx! it worked perfectly...now i have to do this with about 15 sheets. is
    there a fast way to have all the sheets linked like the example below all
    onto another document? they're all in the same cells on the first doc. just
    on diff sheets.
    ex: cells A2 on 15 sheets in doc 1 need to link to doc 2 but on one sheet.
    so cells A2 from all sheets for doc 1 to show on 1 sheet on doc 2. on a2, a3,
    a4, etc...assuming this makes any sense.

    "Andrew" wrote:

    > Easy, be in cell A2 in document 2 and then press '=' and click on 'Window'
    > (in menu bar), selected document 1, click on cell A2 and press 'Enter'..
    > --
    > Andrew
    >
    >
    > "blackstar" wrote:
    >
    > > how would i go about linking a word from one excel doc to another.
    > > ex: cell A2 in document 1 has the word "dog". i want cell A2 in document 2
    > > to show the same word by linking the files together.


+ 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