Variable Cell References?

[Kevin]

Please help with cell references.

I need formula references in wkbk2 to reference values in
wkbk1.

Wkbk1 values are in consecutive rows:

row value
1 10
2 11
3 12 etc

wkbk2 formulas are in every 5th row, but need to reference
every consecutive row in wkbk1:

row value
1 10
6 11
11 12 etc

How can I set up formulas in wkbk2 such that I can copy
and paste the formula in every 5th row, but reference
every consecutive row in wkbk2? Wkbk2 is too large to
input the references manually.

TIA

 

[Frank Kabel]

Hi
try the following in A1 on your second workbook
=OFFSET('[wkbk1.xls]sheet1'!$A$1,INT((ROW()-1)/5))
and copy this to the other rows.

 

[Guest]

It works great Frank. Thanks a lot!!

-----Original Message-----
Hi
try the following in A1 on your second workbook
=OFFSET('[wkbk1.xls]sheet1'!$A$1,INT((ROW()-1)/5))
and copy this to the other rows.

--
Regards
Frank Kabel
Frankfurt, Germany

Please help with cell references.

I need formula references in wkbk2 to reference values in
wkbk1.

Wkbk1 values are in consecutive rows:

row value
1 10
2 11
3 12 etc

wkbk2 formulas are in every 5th row, but need to reference
every consecutive row in wkbk1:

row value
1 10
6 11
11 12 etc

How can I set up formulas in wkbk2 such that I can copy
and paste the formula in every 5th row, but reference
every consecutive row in wkbk2? Wkbk2 is too large to
input the references manually.

TIA

.