Seems easy
 

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

Seems easy
 

=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)



wrote in message
...
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

Seems easy
 

On Dec 11, 5:20 pm, "Bob Phillips" wrote:
=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)

wrote in message

...



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- Hide quoted text -

- Show quoted text -

Thanks-fantastic job Bob! Works great!