Hello again, Alan!
First, love that Avatar!
Correct me if I'm wrong, but does this query simply sort created data, alpha-numerically?
If so, I am trying to find a way, if possible, to generate a sequential, alpha-numeric number that will automatically generate and be permanently assigned (in column A) to a project when it is entered into this worksheet (by selecting a value in one of the columns E, F, or G).
If not, then I am not exactly sure how to enter the Mcode solution you've sent...
I've included a copy of the worksheet in question...
|