Hi, I'm new to the forum, as I'm also quite new to Excel and although variations of this topic have been covered in several other threads, none of them seem to answer my query - unless I just can't find it..
I'm trying to create a single column of stock bin codes for eventual conversion to barcodes. The bin codes run like this:
A1A
A1B
A1C - etc. to A1H, then the sequence starts again with:
A2A
A2B
A2C etc. up to A6H, when the 1st character changes to B and the sequence starts again
This needs to continue until the sequence reaches Z6H
Can anyone please advise me in simple terms how to do this without having to enter each code manually?
Thanks in advance
Bookmarks