How do I create a unique spreadsheet reference?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am amending the expense claim my company uses and I want to be able to
identify each claim by a unique number.

I have played around with using time and date functions to create a
reference number, but I can't really do what I want (It was a pretty bodge
idea to begin with, and I don't seem to be able to get the time reference to
update often enough to be really valid if an employee has the same expense
claim open constantly. Plus of course if they reopen the document later...)

A formula or piece of code that creates a reference one alpha/num more than
the last time the document was opened would be perfect.

All responses gratefully received.

Cheers, P
 
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am amending the expense claim my company uses and I want to be able to
| identify each claim by a unique number.
|
| I have played around with using time and date functions to create a
| reference number, but I can't really do what I want (It was a pretty bodge
| idea to begin with, and I don't seem to be able to get the time reference to
| update often enough to be really valid if an employee has the same expense
| claim open constantly. Plus of course if they reopen the document later...)
|
| A formula or piece of code that creates a reference one alpha/num more than
| the last time the document was opened would be perfect.
|
| All responses gratefully received.
|
| Cheers, P
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unique reference 5
All cells shud contain a unique ref how do i check 4 duplicates? 1
Average Unique 7
Add a unique (sequential) number to "usuername" 4
Creating a Unique Reference from 2 cells 3
Concatenate unique values among duplicates 5
How to Create Unique Reference Numbers for rows of information 1
How do I create a travel expense report by employee, by campus, b. 2

Back
Top