Your a life saver Max.

Thank you for the explanation, it was very helpfull!

Daiv.

"Max" wrote:

"Daiv" wrote:
Thanks a bunch. that worked well.

You're welcome !

I have another worksheet that takes its first value from salary!H4, and the
next one is at salary!H100, then salary!H196
(and every 96 thereafter) [Interval typo slightly corrected to 96 <g]

Put this in the starting cell, and copy down:
=INDIRECT("'salary'!H"&ROW(A1)*96-92)

The construct is similar to the previous except for the multiplier change
from 4 to 96 and the need for a simple arithmetic adjustment since the
starting cell is to point to salary!H4 (so we subtract 92 from 96).

Tinker with this to see what's happening when we copy down ..

Place this in any cell, say C3: =ROW(A1)*96-92
C1 will return as: = (1 x 96) - 92 = 4
( ROW(A1) resolves to: 1 )

When we copy C1 down to C2,
the formula will increment* to: =ROW(A2)*96-92
which now returns: = (2 x 96) - 92 = 100
( ROW(A2) resolves to: 2 )

*ROW(A1) becomes ROW(A2), and so on as we copy down ...

The above hence generates the required number series: 4, 100, 196, ...
for concatenation as the row refs within the INDIRECT
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---