Forum Discussion
Once Block in Numerical Order
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.
One way to do this is by using the ROW function.
Here’s an example:
- In the first cell of the range that you want to number (e.g., cell A1), type =ROW(A1).
- This will return the number of the row that you reference (in this case, 1).
- Drag the fill handle across the range that you want to fill.
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!
