I am trying to set up an inventory system for my wife's online sales business. She needs to add an item number to her products so I have established a system that will be 000-00000-00000000 format. The first three numbers and the second five are for tracking location and selling location. The last eight will be used as an item number. Once we use the 0000001 we don't want to use it again. How can I search the row of cells with the item numbers and find the next available number?

Thanks in advance.