Variable Cell References?

  • Thread starter Thread starter Kevin
  • Start date Start date
K

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
 
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.
 
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
Click to expand...
.
Click to expand...
 
Back
Top