Formula to Display cell contents rows apart in order in a new col?

[jbridges]

I have a spreadsheet with information not formatted the way i need.
For example i want to get information 35 rows apart all the way down to
row 10000 in order on a seperate worksheet col. I have the
=ARCustomerListing.rpt!G9 which displays the correct value, but now I
need =ARCustomerListing.rpt!G44, =ARCustomerListing.rpt!G79, ect all
the way to =ARCustomerListing.rpt!G10000. Is there an easy way to do
this? I have to do this for alot of information. I was able to
concatenate "=ARCustomerListing.rpt!G" with the correct numbers, but
you have to double click each cell and hit enter for the formula to
display the correct information.

I know i am missing something, thanks in advance.

 

[Art Farrell]

Hi,

Try-

=INDIRECT("ARCustomerListing.rpt!G"&35*ROW()-26)

if your starting row is 1. If row 2 add 35 to 26, etc.

CHORDially,
Art Farrell