Seems easy

[pignataro1]

Hello all,
Following formula is located in B6:

='VT by Brand 07-09'!R6

In B7 need same data from formula only 6 rows down (='VT by Brand
07-09'!R12), same for B8 another 6 rows down (R18) etc... for many
sheets. Is there a way to write the formula into B6 so these other
cells reference it and still go down the necessary 6 lines from each
other to get the data. B6 will have to change monthly to update so
want to be able to change only 1 cell B6 and have all other
automatically update.

Thanks

 

[Bob Phillips]

=INDIRECT("'VT by Brand 07-09'!R"&(ROW()-5)*6)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[pignataro1]

=INDIRECT("'VT by Brand 07-09'!R"&(ROW()-5)*6)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)









- Show quoted text -

Thanks-fantastic job Bob! Works great!