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 :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
=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 ]
Like this thread? Share it with others