Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Link cells won't link properly.

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Toronto
    Posts
    275
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Information is stored on one page in cells a1:a5.

    I want to link to this information on page 2 in cells, a5, A8, A11 etc.

    When you link page 2 cell a5 to page 1 cell a1, it doesn't copy down correctly. I would like to link non successive cells to successive data. Is this possible.?

    Thanks,

    Jamie

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-18 11:44, boxsterman wrote:
    Information is stored on one page in cells a1:a5.

    I want to link to this information on page 2 in cells, a5, A8, A11 etc.

    When you link page 2 cell a5 to page 1 cell a1, it doesn't copy down correctly. I would like to link non successive cells to successive data. Is this possible.?

    Thanks,

    Jamie
    in Sheet 2, cell A5, try the following :

    =INDIRECT(+"Sheet1!A"&((ROW()-2)/3))

    and then copy it to cells a8, a11, a14, a17 etc



    _________________
    Hope this helps,
    Chris


    marker

    [ This Message was edited by: Chris Davison on 2002-04-18 14:13 ]

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
  •