Results 1 to 2 of 2

Thread: Linking Cells

  1. #1
    Join Date
    Nov 2005
    Posts
    3

    Unanswered: Linking Cells

    Hi,

    Does anyone know about linking cells in worksheets using the "=" sign?

    If I delete a row in my main worksheet or add a new one in, I get errors in the linked sheet or it does not update.

    Does anyone know a way around this, without also modifying the linked sheet?


    Tim

  2. #2
    Join Date
    Oct 2003
    Posts
    311
    Instead of using the cell reference in the formula , name the cell, ie: insert name define Q1Sales


    then in your linked sheet when you do = and then select the cell in the main sheet, you are referencing the Named Range Q1Sales, not Cell A1

    If rows are added or deleted Range Q1Sales is still the same

Posting Permissions

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