Generating autonumbers

Hello,
I have a worksheet that I use for my invoices.
The invoice number nomenclature is: TPT_1500A
Each time I print an invoice, I want an invoice number (TPT_1502B) to be
automatically printed.
Can/will someone direct me to example/resources to help me???


Thank you,
--
Charles L. Phillips

J.E. McGimpsey has instructions for creating sequential invoice numbers:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

You could adapt that to your invoice, using a second cell, with a
formula, to concatenate the letters.

Charles L. Phillips wrote:
> Hello,
> I have a worksheet that I use for my invoices.
> The invoice number nomenclature is: TPT_1500A
> Each time I print an invoice, I want an invoice number (TPT_1502B) to be
> automatically printed.
> Can/will someone direct me to example/resources to help me???
>
>
> Thank you,
> --
> Charles L. Phillips
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hello,
"Thank You", this will really help...
Do you know of ANY other Excel resources???



"Debra Dalgleish" <[email protected]> wrote in message
news:[email protected]...
> J.E. McGimpsey has instructions for creating sequential invoice numbers:
>
> http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
>
> You could adapt that to your invoice, using a second cell, with a
> formula, to concatenate the letters.
>
> Charles L. Phillips wrote:
> > Hello,
> > I have a worksheet that I use for my invoices.
> > The invoice number nomenclature is: TPT_1500A
> > Each time I print an invoice, I want an invoice number (TPT_1502B) to be
> > automatically printed.
> > Can/will someone direct me to example/resources to help me???
> >
> >
> > Thank you,
> > --
> > Charles L. Phillips
> >
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>

I don't know of any other resources for sequential invoice numbers in
Excel, but you might find some in Google:

http://www.google.com/advanced_search?


Charles L. Phillips wrote:
> Hello,
> "Thank You", this will really help...
> Do you know of ANY other Excel resources???
>
>
>
> "Debra Dalgleish" <[email protected]> wrote in message
> news:[email protected]...
>
>>J.E. McGimpsey has instructions for creating sequential invoice numbers:
>>
>> http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
>>
>>You could adapt that to your invoice, using a second cell, with a
>>formula, to concatenate the letters.
>>
>>Charles L. Phillips wrote:
>>
>>>Hello,
>>>I have a worksheet that I use for my invoices.
>>>The invoice number nomenclature is: TPT_1500A
>>>Each time I print an invoice, I want an invoice number (TPT_1502B) to be
>>>automatically printed.
>>>Can/will someone direct me to example/resources to help me???
>>>
>>>
>>>Thank you,
>>>--
>>>Charles L. Phillips
>>>
>>>
>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

"Thank You"...



"Debra Dalgleish" <[email protected]> wrote in message
news:[email protected]...
> I don't know of any other resources for sequential invoice numbers in
> Excel, but you might find some in Google:
>
> http://www.google.com/advanced_search?
>
>
> Charles L. Phillips wrote:
> > Hello,
> > "Thank You", this will really help...
> > Do you know of ANY other Excel resources???
> >
> >
> >
> > "Debra Dalgleish" <[email protected]> wrote in message
> > news:[email protected]...
> >
> >>J.E. McGimpsey has instructions for creating sequential invoice numbers:
> >>
> >> http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
> >>
> >>You could adapt that to your invoice, using a second cell, with a
> >>formula, to concatenate the letters.
> >>
> >>Charles L. Phillips wrote:
> >>
> >>>Hello,
> >>>I have a worksheet that I use for my invoices.
> >>>The invoice number nomenclature is: TPT_1500A
> >>>Each time I print an invoice, I want an invoice number (TPT_1502B) to
be
> >>>automatically printed.
> >>>Can/will someone direct me to example/resources to help me???
> >>>
> >>>
> >>>Thank you,
> >>>--
> >>>Charles L. Phillips
> >>>
> >>>
> >>
> >>
> >>--
> >>Debra Dalgleish
> >>Excel FAQ, Tips & Book List
> >>http://www.contextures.com/tiptech.html
> >>
> >
> >
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>