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

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.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=379577

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" wrote:

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

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

"greg7468" wrote:


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.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=379577