austenr
07-22-2015, 06:05 AM
I have a user form that people use to populate data into a sheet. What I want to happen is for the next project number to automatically populate when the form opens. The projects are numbered starting with 1 in column A. So if the user opens the form and there are already 10 projects on the sheet the form should pop up with 11 in the Project ID field. Just not sure on how to accomplish this.