ianjwerner
New Member
- Joined
- Sep 20, 2023
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
I am trying to Enter a value (total number of rows/records) and I would like Excel to then "spill" 1-# in a sequence 1, 2, 3, 4, 5, etc in a column.
example: enter "500" in cell B8
In cell B11 a, B12 2, B13 3, Etc....
example: enter "500" in cell B8
In cell B11 a, B12 2, B13 3, Etc....
500 | |
| FILL IN (1 - MAX) | INVOICE NUMBER |
| *Sequence Number | *Receipt Number |
1 | 180834 |
2 | 180920 |
3 | 388908 |
4 | 1000077 |
5 | 1000185 |
6 | 5749856 |
7 | 5760517 |
8 | 10000080 |
9 | 10000081 |
10 | 10000082 |
11 | 10000083 |
