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

Thread: How do I link a cell to another cell even if that cell moves

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

    Default

    Here’s my question to you. I am using excel 2002 at school and I am trying to set up a hockey pool stats worksheet.

    On Sheet 1, I have my master list of 100 players and on sheet 2 I have 4 individual roster lists each containing 25 player from the master list.

    Example
    Sheet 1
    Player Team Pos Point
    Total
    Sundin Tor Fwd 1 (let's call the point total cell D3)
    99 more players

    On sheet 2 I have the same setup
    Player Team Pos Point
    Total
    Sundin Tor Fwd =Sheet1!$D$3
    24 more players

    My problem is that when I sort Sheet 1 to display point leaders, the link on sheet 2 (=Sheet1!$D$3) is no longer accurate because Sundin on sheet 1 is no longer at cell D3.

    How can I assign a link or formula to Sundin's cell even if it moves?

    Thanks everyone for your help!

  2. #2
    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

    Consider using VLOOKUP.

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

    Default

    Thanks Mark....
    God that was easy... I feel stupid now!!
    hehe
    Even my computer professor didn't know what to do!
    Thanks Again

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
  •