Alphabetic autofill

[dogisnuts]

I want Excel to autofill our inventory system. It is alphabetic though.
AAA, AAB,...-ZZZ. I understand that you have to build a macro to do it. Any
suggestions?

Thank you

 

[greg7468]

Hi,
you can do it with a formula,

put alphabetic autofill in the search.

I think it's the first one on there.

p.s I notice they are all your queries,

I'd suggest rather than keep reposting the same question you query the
replies given if you do not understand them.

HTH.

 

[Kassie]

Hi dogisnuts

You can use the following formula, previously posted by Max

=UPPER(IF(ROW(A1)>18278,CHAR(96+INT(MOD(ROW(A1)-18279,456976)/17576)+1),"")&
IF(ROW(A1)>702,CHAR(96+INT(MOD(ROW(A1)-703,17576)/676)+1),"")&IF(ROW(A1)>26,
CHAR(96+INT(MOD(ROW(A1)-27,676)/26)+1),"")&CHAR(97+MOD(ROW(A1)-1,26)))

 

[dogisnuts]

Thanks for the info. I am still trying to figure out all this stuff.