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

Thread: External Reference

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    East Coast
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What is the syntax for referencing a cell from another worksheet?
    Thanks.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,584
    Post Thanks / Like
    Mentioned
    30 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-02-21 11:35, believer wrote:
    What is the syntax for referencing a cell from another worksheet?
    Thanks.
    Lets say that you have a number in A1 in Sheet2 and you want to make a cell (say, C1)in Sheet1 equal to that value:

    In C1 in Sheet1 enter: =Sheet2!A1


  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-21 11:35, believer wrote:
    What is the syntax for referencing a cell from another worksheet?
    Thanks.
    If that worksheet is in another workbook use...

    =[Book1]Sheet1!$A$1

  4. #4
    New Member
    Join Date
    Feb 2002
    Location
    East Coast
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It worked, thank you both very much.

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
  •