Automatically display next RMA Number

[steveo0707]

I have a spreadsheet that has four columns. I wanted to create a user form that will allow the operator to pick whether it is our part or a customer part. Once they pick i need the selection automatically transfer to the cell and automatically pick the next sequential number in the RMA list and display it in the appropriate cell.

A bit rusty on my VBA skills. Any help would be much appreciated

 

[awoohaw]

Try this, but really unsure if it fits your needs since, I don't think you gave all the information for a complete answer, but maybe you did and this will work.
Create a table to hold your data.
In your Column you want your RMA number (You should have given that formula)
Add the "Form" tool to your quick access tool bar (Not really necessary but it makes things easier).

Add your data.

 

[steveo0707]

Try this, but really unsure if it fits your needs since, I don't think you gave all the information for a complete answer, but maybe you did and this will work.
Create a table to hold your data.
In your Column you want your RMA number (You should have given that formula)
Add the "Form" tool to your quick access tool bar (Not really necessary but it makes things easier).

Add your data.

View attachment 92319

This was all I needed. That worked perfectly. Thank you, awoohaw!

 

[steveo0707]

This was all I needed. That worked perfectly. Thank you, awoohaw!

Is there a way to have excel automatically insert a row only after I enter Customer Name and keep the sequential numbering?

 

[steveo0707]

Try this, but really unsure if it fits your needs since, I don't think you gave all the information for a complete answer, but maybe you did and this will work.
Create a table to hold your data.
In your Column you want your RMA number (You should have given that formula)
Add the "Form" tool to your quick access tool bar (Not really necessary but it makes things easier).

Add your data.

View attachment 92319

Hello awoohaw,
My NCMR number is 2039 right now. How do I get the formula above to count by one instead of 100

 

[steveo0707]

Hello awoohaw,
My NCMR number is 2039 right now. How do I get the formula above to count by one instead of 100

View attachment 93382

Here is the formula I have in there now. ="NCMR"&TEXT(ROW(A3)-3,"2039")

 

[awoohaw]

why do you have "2039" as your format?
the formula I gave you earlier is:

="NCMR" & Text(Row(A3)-2,"000#")

(If you are looking at the formulas in different rows, in Row 2038, the formula should be

="NCMR" & Text(Row(A2038)-2037,"000#")

 

[steveo0707]

Duh, I got it. Not sure what I was thinking.

Thank you for your help.