Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: How to link two sheets into a third sheet?

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am in a dilemma. Here`s my problem (hope I can make myself clear - I`m still learning my way through excel!)
    In sheet one, if I enter the file path of a second workbook (e.g in cell A1), is there any way that the second workbook will pop up when I enter the file path??
    Basically I want to take certain data out of the second workbook and paste it into the first and I want an easy way of doing it without writing a macro.

    Is this at all possible or am I asking too much??

  2. #2
    New Member
    Join Date
    Feb 2002
    Location
    East Sussex
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    To link multiple workbooks, open both the source and destination workbooks. In the destination cell, type an = sign, then switch to the source workbook (Window menu) and click in the source cell. Excel will write the formula for you.

    As for having the source workbook open when you click on a cell, that sounds like a VBA issue, which I am a total dumbo on.

    Hope this helps,
    sc

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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