Link Increments

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array with many cells from a row but not in order or together 11
Run two macros for two different sheets 11
Copy columns and paste with blank column between 5
Match based on a lookup and then flag 4
Fill Down to Last Value 3
Code works but goes into endless loop and crashes 1
Match and Reconcile 2
Return the values in another sheet 3

Top