How do I assign a unique ID number to an invoice sheet I created?

I have a formula that currently generates a unique id# but it changes
everytime I click thru this sheet or open it up again. I need a unique id #
that will stay permanent once assigned. PLEASE HELP!!

So what's the formula you are using now?


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




"Matt" <[email protected]> wrote in message
news:[email protected]...
>I have a formula that currently generates a unique id# but it changes
> everytime I click thru this sheet or open it up again. I need a unique id
> #
> that will stay permanent once assigned. PLEASE HELP!!

How about this:
Use the formula you created for generating unique ID - use the formula not
within the invoice range.
And use [copy-paste special/value] for any new invoice - paste to the cell
you want to store ID.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
=================================
"Matt" <[email protected]> wrote in message
news:[email protected]...
>I have a formula that currently generates a unique id# but it changes
> everytime I click thru this sheet or open it up again. I need a unique id
> #
> that will stay permanent once assigned. PLEASE HELP!!