I am trying to make some locations for my warehouse using Excel. I want it to automatically increment the field so that I do not have to type whole list by hand. There are 7 fields that will make up 1 location. The first location would be AA11001.

The first 2 fields will follow the same increase throughout the warehouse, so it would go AA, AB, AC, AD, BA, BB.... The first letter will continue until "Y" and the second will never go above "D"

The next to fields will vary depending on location but will follow the same general increase that the first 2 did. 11, 12, 13, 14, 15, 16, 21..... until it reaches 99.

The last three will be tied together and will need to follow 001, 002, 003... until 012.

I have tried searching the forms but I have not seen anything quite like this in my searches. Any help would be greatly appreciated.