Incremental Numbering

  • Thread starter Thread starter fastcar
  • Start date Start date
F

fastcar

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 said:
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.
Click to expand...

With the 2 initial inputs in
G7......2378
G16....2379
Click to expand...

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

---
 
Back
Top