Hello,
I have the following formula in a workbook on the first sheet that
references a 2nd sheet
in B6='VT by Brand 07-09'!F2
in B7 I want to go 6 rows down and currently have this formula=INDIRECT
(ADDRESS((ROW()-5)*6-4,5,,,"VT by Brand 07-09"))
I want to continue all the way down to B38 going 6 rows down each
time.



I have the same situation in C6='VT by Brand 07-09'!F4
in C7 I want to go 6 rows down and currently have this formula=INDIRECT
(ADDRESS((ROW()-5)*6-4,5,,,"VT by Brand 07-09"))
I want to continue all the way down to B38 going 6 rows down each
time.


I have the same situation in F6='VT by Brand 07-09'!F3
in F7 I want to go 6 rows down and currently have this formula=INDIRECT
(ADDRESS((ROW()-5)*6-4,5,,,"VT by Brand 07-09"))
I want to continue all the way down to B38 going 6 rows down each
time.

I have the same situation in G6='VT by Brand 07-09'!F5
in G7 I want to go 6 rows down and currently have this formula=INDIRECT
(ADDRESS((ROW()-5)*6-4,5,,,"VT by Brand 07-09"))
I want to continue all the way down to B38 going 6 rows down each
time.

What are the problems here???

Thanks