Link Increments
 

Hi

I have 2 sheets, sheet 1 is to show data from every 8 rows from sheet 2

e.g. on sheet 1 my links are
=sheet2!b5
=sheet2!b13
=sheet2!b21

I have 400 of these to enter into sheet 1 and another 500 in another book,
how can i do this programatically without having to manually edit every cell?


Many many thanks

Kerry

Link Increments
 

=Indirect("sheet2!B" & 4 + 8*row(A1))

then drag fill down the column

--
Regards,
Tom Ogilvy


"Kerry" wrote in message
...
Hi

I have 2 sheets, sheet 1 is to show data from every 8 rows from sheet 2

e.g. on sheet 1 my links are
=sheet2!b5
=sheet2!b13
=sheet2!b21

I have 400 of these to enter into sheet 1 and another 500 in another book,
how can i do this programatically without having to manually edit every
cell?


Many many thanks

Kerry