Alphabetic autofill

#1 06-16-2005, 02:05 AM

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 · #2 06-16-2005, 07:58 AM

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.

#3 06-16-2005, 07:05 PM

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

#4 06-16-2005, 11:05 PM

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
>
>

Welcome to the Excel Forum

Forum Statistics