Repeating Columns

Type in the first two entries (ending 001 and 002), then select both cells, then drag down the fill handle (the small black square in the bottom right corner of the cursor) until you reach 152. Then change your level and enter the first two with that level and repeat.

Hope this helps.

Pete

P.S. Not sure what your "level" is.

It's all in the same column. The column is 0060010023(006-Room, 001-Aisle, 002-bay, 3-Level)

So you want the bay to increase from 001 to 152 while the level is at 1, then again while the level is at 2, and so on up to the level equals 5? The room and aisle remain the same?

Pete