Excel spreadsheet
 

Hello,
I am attemting to put a value in spreadsheet-Total CS (B6) by
referring to the next spreadsheet over with following formula='VT by
Brand 07-09'!E2. From there go down exactly 6 cells =INDIRECT("'RI by
Brand 07-09'!S"&(ROW()-5)*6-2) and put that value in first spreadsheet
Total CS (B7). I want to continue 6 cells down each time and finish
at B37. What is wrong with my formula (s)????

Excel spreadsheet
 

First of all, your B7 formula is referring to a different sheet than your B6
formula. Your row computation causes B7 to look in E10, which is 8 (instead
of 6) rows below E2. The following version works for me:

=INDIRECT(ADDRESS((ROW()-5)*6-4,5,,,"VT by Brand 07-09"))

Put in B7 and copy down through B37.

Hope this helps,

Hutch

"Ric" wrote:

Hello,
I am attemting to put a value in spreadsheet-Total CS (B6) by
referring to the next spreadsheet over with following formula='VT by
Brand 07-09'!E2. From there go down exactly 6 cells =INDIRECT("'RI by
Brand 07-09'!S"&(ROW()-5)*6-2) and put that value in first spreadsheet
Total CS (B7). I want to continue 6 cells down each time and finish
at B37. What is wrong with my formula (s)????

Excel spreadsheet
 

On Feb 21, 12:50*pm, Tom Hutchins
wrote:
First of all, your B7 formula is referring to a different sheet than your B6
formula. Your row computation causes B7 to look in E10, which is 8 (instead
of 6) rows below E2. The following version works for me:

=INDIRECT(ADDRESS((ROW()-5)*6-4,5,,,"VT by Brand 07-09"))

Put in B7 and copy down through B37.

Hope this helps,

Hutch



"Ric" wrote:
Hello,
* * I am attemting to put a value in spreadsheet-Total CS (B6) by
referring to the next spreadsheet over with following formula='VT by
Brand 07-09'!E2. *From there go down exactly 6 cells =INDIRECT("'RI by
Brand 07-09'!S"&(ROW()-5)*6-2) and put that value in first spreadsheet
Total CS (B7). *I want to continue 6 cells down each time and finish
at B37. *What is wrong with my formula (s)????- Hide quoted text -

- Show quoted text -

Tom,
Thank you very much!!!! Works great