How to Create Unique Reference Numbers for rows of information

's Computer Specifications

Hi

I would like to be able to create a unique reference number automatically
when entering a record in the row.

Can this be done?

Thanks

's Computer Specifications

Dear Dave

Col A will have the unique reference number
A1 = Header
A2 = If(B2="","",Row()-1)
Paste the formula to the below cells..

If this post helps click Yes
---------------
Jacob Skaria

"Dave" wrote:

> Hi
>
> I would like to be able to create a unique reference number automatically
> when entering a record in the row.
>
> Can this be done?
>
> Thanks

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I create a unique spreadsheet reference?	=?Utf-8?B?UGF1bA==?=	Microsoft Excel Worksheet Functions	1	1st Nov 2006 07:14 PM
creating unique reference numbersusing lettersand numbers	=?Utf-8?B?amFuZWFzaGFycA==?=	Microsoft Access Getting Started	1	12th Apr 2006 03:38 PM
How do I create a visible unique reference number in Access?	=?Utf-8?B?UmF5?=	Microsoft Access	8	29th Mar 2006 01:40 PM
I want to create unique randomn numbers	=?Utf-8?B?Y2hhcmxpZWtpbmc0NzQ3?=	Microsoft Excel Misc	5	16th Feb 2006 01:53 PM
Can a macro create a hyperlink with unique cell information?	=?Utf-8?B?RGVzaXJlZQ==?=	Microsoft Excel Programming	3	22nd Oct 2004 07:49 PM