Hello,

I would like to be able to enter a number is Excel worksheet say G7 and
have that number incremented by 1 every 9 rows.

eg.

G7......2378
G16....2379
G15....2380
and so on.

This can either be done by running a macro or automaticaly


--
fastcar
------------------------------------------------------------------------
fastcar's Profile: http://www.excelforum.com/member.php...o&userid=16457
View this thread: http://www.excelforum.com/showthread...hreadid=560529

"fastcar" wrote:
I would like to be able to enter a number is Excel worksheet say G7 and
have that number incremented by 1 every 9 rows.
eg.
G7......2378
G16....2379
G25....2380 [corrected]
and so on.

With the 2 initial inputs in
G7......2378
G16....2379

think we could just select G7:G24, then fill* down as far as desired
*drag the fill handle at the bottom right corner of G24
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---