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

The aisle will increase as well but that's something I can repeat when the aisles complete. The bay will increase and the level will list as 1-5. The bay will repeat 5 times with each level.

0060010011
0060010012
0060010013
0060010014
0060010015
0060010021
0060010022
0060010023
0060010024
0060010025

0060061042
0060061043
0060061044
0060061045
0060061055
0060061065
0060061075
0060061085

The last 4 rows are what the formula gave me.

Will that not bring back anything ending in 1?

Hello
The problem is that its difficult to build a formula because its not a linear progression of numbers.
With 0060060011 you need to add one four times, reaching 0060060015 and then add ten and
deduct 4 to get to the next code 0060060021.
Using If statements this would be possible, but I think that it would be easier to build up the list in (say) 3 separate columns

Cols 1 2 3 4
006006 001 1 Concatenate Col1&Col2&Col3
006006 001 2
006006 001 3
006006 001 4
006006 001 5

Col 1 is a formula that repeats 006006 as many times as necessary.
Col 2 Repeats the value in the previous row unless col 3 of the previous
row is 5, inwhich case it adds 1 to the value in the previous row
Col 3 Adds one to the value in the row above, or sets it back to one if the row
above has reached five.

Using this strategy you can build a long list of codes and concatenate the results
as shown. Finally if you need the codes across the columns rather than by rows
you can do this with Paste Special /Transpose.

HTH

Hello Again
Sorry about the spacing of my column headers above. Col 4 is the contatenation of 1,2 and 3.

Hello Martin
Agreed .... Your solution is an "easier to operate" solution than mine.

Thank you MartinDwilson! It worked. You saved me hours of work!