I have a sheet developed for creating purchase order numbers using the auto-number system. Due to the fact we create a lot of purchase order numbers, I have reverse sorted via the auto-number column so users do not have to scroll through many po's to get to the bottom of the page.
Is there a way to automatically have an empty row at the top of the sheet waiting to enter the next auto-numbered purchase order. I would like to eliminate the need for users to have to add a row to create a purchase order.
Al W
