Apr 13 2023 05:24 AM
I hope someone can help me because I know this is possible, I just can't find the solution.
I have an Excel PO form that I use, and I need the PO# to automatically populate in numerical order every time the Excel form is opened and used. Example: PO# for Vendor ABC is 4501, and the next sequential PO # would be 4502 for the next vendor.
Just one block needs to keep the numerical sequence every time the form is used.
Apr 13 2023 05:45 AM
One way to do this is by using the ROW function.
Here’s an example:
As you drag the fill handle, Excel will automatically fill in the cells with sequential numbers.
This method will automatically number the rows in the range that you specify.
I hope this helps!