LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 661
Default How do I create a unique spreadsheet reference?

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Filename reference in Spreadsheet XML issue Mike Excel Discussion (Misc queries) 1 August 2nd 10 09:40 PM
Trying to create a grid type spreadsheet JHL Excel Worksheet Functions 0 July 26th 06 05:56 PM
Create Macro to Copy Data from one spreadsheet to another Cheri Excel Discussion (Misc queries) 19 July 21st 06 10:54 PM
External reference to spreadsheet names (tabs) help needed. cuyuni Excel Discussion (Misc queries) 2 July 15th 06 12:51 PM
how do I reference a spreadsheet in a cell Lee_Wrede Excel Worksheet Functions 2 February 25th 05 02:11 AM


All times are GMT +1. The time now is 08:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"