I have a purchase order spreasheet working with. I would like it to
automatically generate a unique identifier (PO number) upon opening the file;
is this possible? or some formula to automatically pull in the next
sequential #?
I have a purchase order spreasheet working with. I would like it to
automatically generate a unique identifier (PO number) upon opening the file;
is this possible? or some formula to automatically pull in the next
sequential #?
I have an invoices download at http://www.officearticles.com/downloads/
It does just what you want. Perhaps you can steal the code from it.
************
Anne Troy
www.OfficeArticles.com
"ritarowe" <[email protected]> wrote in message
news:[email protected]...
>I have a purchase order spreasheet working with. I would like it to
> automatically generate a unique identifier (PO number) upon opening the
> file;
> is this possible? or some formula to automatically pull in the next
> sequential #?
ritarowe, here is one way to do it, put in workbook open code
Sheets("Sheet1").Range("A1").Value = _
Sheets("Sheet1").Range("A1").Value + 1
If this is a temple have a look here for other ways to do it
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"ritarowe" <[email protected]> wrote in message
news:[email protected]...
>I have a purchase order spreasheet working with. I would like it to
> automatically generate a unique identifier (PO number) upon opening the
> file;
> is this possible? or some formula to automatically pull in the next
> sequential #?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks