OMG!! I just figured out how to alter your formula to make it work for me!!
Thank you so much for your help!! You've saved me a TON of time!!

T.

"zvkmpw" wrote:

I need it to go out to the letter "F" before it starts on the next count.

If I understand correctly, maybe this will help.

In A1 put
=(INT((COLUMN()-1)/6)+1)&CHAR(65+MOD(COLUMN()-1,6))
and copy rightward as far as needed.