“Stamping” an auto generated reference number
Is there a way to auto generate a unique number that will stay with the adjacent data record? My problem at the moment is when a record is deleted or the data sorted the ref number changes. I am using Excel 2008
Also, can someone direct me to an online glossary of terms, functions and syntax for VBA please?
Thanks in anticipation
Last edited by Fairport; 04-28-2009 at 07:49 PM.
Change your existing code to
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks, it works up to a point, but having cut and pasted your code into my working spreadsheet the numbers start at 92 and I cant find a way to reset it to 1. Any reason for that?
Have you got existing numbers there?
No. The spreadsheet had no data in whatsoever apart from headings. I have attached a blank example.
There must have been some data somewhere in Column A, because when I cleARED THE COLUMN THE NUMBER WORKED. i HAVE ALSO AMENDED THE CODE SLIGHTLY
Re: “Stamping” an auto generated reference number
Thanks royUk, that seems to have solved the problem. I will check column A in the original spreadsheet. Thanks also for the modified code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks