Hello All,
I am trying to do what I am sure can be done with a formula but not sure how to get it done.
I have been tasked to change the way we track our job files. We have previously tracked the Job files in a word document which has the Job Number, the Job Name, and Job Creator. We assign each job a number which is the year first, a dash (-) and a sequential number. For example, the first job we did in 2013 would be 13-001, the second 13-002, etc. Part of the reason for conversion to excel was to automate some of the simpler tasks and making input more efficient and less prone to human error. As such, I would like my table to automatically fill in the "Job Number" field with the next number in the sequence (as in my above example, when the user tabs on the previous job, it would automatically fill in 13-003 for the Job Number).
How to I go about writing a formula to get this accomplished? TIA for your help.
Bookmarks