How to assign a reference number for each item?
For examples,
today is 10/7/2013, I want to assign a reference number 20130710001 for the first item,
10072013 mean 10/7/2013, 001 mean the first item.
Thus, 20130711001 means the second item of 11/7/2013.
How can I use VBA to assign a reference number for each item?
Thanks, jason.
Here is my code, I have set iRow before. But I cant use this code to do the following requirement
17/7/2013, I enter one data --> it output 20130717001
18/7/2013, I enter one data --> it output 20130718002 , how can I change it to 20130718001??
Please Login or Register to view this content.
Bookmarks