How to link to values in another worksheet / workbook

    If you want data from one worksheet to be linked to, or shown in another worksheet then follow these steps:

    1. In the sheet you want to link to (source) select the cell where the value is.
    2. Right click and select Copy.
    3. In your main sheet (target), select the cell where the value is to be displayed.
    4. Right click and select Paste Special.
    5. When the dialog box appear click on the Paste Link button.
    6. The value in the source sheet will now be reflected in the target sheet.
    7. Every time the source sheet is updated, the target sheet will also be updated with the new values.
    8. The same procedure can be applied to link to data in another workbook.

    Applies to : Excel 2003

    Comments

    1. Robert says:

      You are awesome! Just the right information for me, I greatly appreciated it.
      Regards, Robert

    2. Christian Mercado says:

      Thanks a lot for that tip! Have a nice day!

      -Christian (Puerto Rico)

    3. Raven says:

      Thnk this was helpful to me however
      when i type some data in source sheet & save its not reflecting in target file wats the solution for this

    4. admin says:

      Select the cell in the target sheet and hit F2 key. If you see a formula with reference to the source sheet and the source cell, then your link should be OK. In this case check to make sure that you have auto calculation on.
      If there is no reference to the source sheet that means you didn’t paste the link properly.

    5. Rafay says:

      Very simple. I was trying to do this. Thanks for the help.

    6. admin says:

      You are we welcome.

    7. Firoz says:

      Thanks for the help, i was trying this for a long time

    8. admin says:

      You are welcome.

      I would like to apologize to everybody for the late replies due to other obligations.

    9. Namratha says:

      Thanks… I would have never figured it out myself. Thanks you are brilliant :)

    10. admin says:

      You are welcome, and thanks for the nice comment.

    11. Michael says:

      Your tip was right on. Thank you.