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