Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    multi worksheet cell reference (2007)

    I'm hoping that this is an easy question. I have a cell on sheet 2 that I want to reference on sheet1 so that when I update the sheet2 content it automatically updates the sheet one reference.

    Thanks in advance,

    Techauthor (Steve)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: multi worksheet cell reference (2007)

    Select the cell on Sheet1 where you want to place the reference.
    Type = to start a formula.
    Click on the sheet tab of Sheet2. You should see something like =Sheet2! in the formula bar.
    Click on the cell that you want to refer to. You should see something like =Sheet2!B23 in the formula bar.
    Press Enter or click on the green check mark in the formula bar.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: multi worksheet cell reference (2007)

    Steve,

    Here is another method:

    1. Right click on the cell on sheet 2 and choose COPY from the popup menu.
    2. Click on the Sheet1 tab.
    3. Right click in the cell (on Sheet 1) where you want the reference (from Sheet 2) to appear.
    4. From the popup menu, choose PASTE SPECIAL
    5. A dialog box will appear; click on the button at the bottom called PASTE LINK.

    Thats it!!

    PS: Using this method, you can select a range of cells, copy them all in one go, and paste them with a link on another sheet.
    Regards,
    Rudi

Posting Permissions

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