LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pat Pat is offline
external usenet poster
 
Posts: 122
Default Auto unique numbering


I want a unique number automatically inserted using the Worksheet_Change
event. When a cell in column D contains a value column E will automatically
display a unique 13 digit number which is incremented by one. The worksheet
will be sorted regularly, so taking away the worry of knowing what the last
number used to avoid duplicates is vital.

Anyone got the know-how on this?
Many thanks!
Pat



 
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
Create unique numbering system from three bits of data skimark Excel Discussion (Misc queries) 4 June 23rd 09 01:13 PM
aUTO nUMBERING Udayan New Users to Excel 2 March 12th 09 10:07 AM
Auto Numbering Andy JL New Users to Excel 3 November 23rd 05 05:09 AM
Auto Numbering jharkins Excel Discussion (Misc queries) 2 July 28th 05 11:46 PM
Auto Numbering Nicola Brennan[_2_] Excel Programming 1 November 9th 03 04:40 PM


All times are GMT +1. The time now is 06:03 PM.

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"