Hello all,
I need to create an Incident Log for the small police department for which I am employed.
It needs to automatically generate the next incident number in the next row when someone begins entering non-numerical values in the columns.
Our reports are 7 digit numbers (MMYY001, MMYY002, MMYY003, etc.)
The pic below shows an idea of what I need. Any help would be greatly appreciated.
a1="MMYY"&TEXT(ROW(),"000") and drag down.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Try adding this code to the VBA module for the sheet (e.g. Sheet1)
This code will start a new number sequence when the new month starts
Please Login or Register to view this content.
Martin
Formula in A2 then fildown.
=IF(B2="","",TEXT(B2,"mmyy")&TEXT(SUMPRODUCT((YEAR(B$2:B2)=YEAR(B2))*(MONTH(B$2:B2)=MONTH(B2))+0),"000"))
able to adjust the change(s) .
Last edited by jindon; 09-08-2017 at 12:33 AM. Reason: Typo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks