displaying next sequential number with the click of a button

Occasional Visitor

We are getting rid of a piece of software that generates a sequential SKU for our stock parts and want to create a version in excel in the interim.

 

What I would like is to have a button to press that shows the next unused number from a list and will never show any of the previously used numbers to avoid duplication. There are also 3 letters before the sequential number that do not change.  

 

e.g press the button -> displays "ABC00000" ->press the button -> displays "ABC00001" etc. 

 

any suggestions would be appreciated 

1 Reply

@Grmcmrn Mind if I ask how the list you're referencing is generated/updated?  e.g. are you pulling serial numbers from a database? 

 

I read this "e.g press the button -> displays "ABC00000" ->press the button -> displays "ABC00001" etc. " as implying the button will not only read from but also update the list.  

 

If that's not the case, can I ask why you want to press a button to return the next value when the formula can display it automatically whenever the list is updated?