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
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.
Last edited by greg7468; 06-16-2005 at 08:02 AM.
Greg.
"The most overlooked advantage of owning a computer is that if they foul up there's no law against whacking them around a bit."
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks