Link cells won't link properly.

[boxsterman]

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

 

[Chris Davison]

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