VBA - Serial Numbers

[Toastis]

I need some assistance creating a VBA code. I am pretty sure a standard formula won't work. Warehouse personnel will use this tracker. options would be enter a new tote or an old tote (old totes will already have numbers, new totes need a number). On the 2nd tab I associated the seriel number scheme applicable to each warehouse. I need code that will tell enter the next serial number and then cross it off the list once used, so to speak.

Any ideas?

Warehouse	New Or Old?	Tote Serial Number
1	N	?
1	O	1234
1	N	?

<tbody>
</tbody><colgroup><col><col><col></colgroup>

1-PHX	2-TUC	3-CAL	4-LAV	6-SAF	7-ELP	8-CHV	9-BLM	10-ABQ
10000	20000	30000	40000	60000	70000	80000	90000	50000
10001	20001	30001	40001	60001	70001	80001	90001	50001
10002	20002	30002	40002	60002	70002	80002	90002	50002
10003	20003	30003	40003	60003	70003	80003	90003	50003
10004	20004	30004	40004	60004	70004	80004	90004	50004
10005	20005	30005	40005	60005	70005	80005	90005	50005
10006	20006	30006	40006	60006	70006	80006	90006	50006
10007	20007	30007	40007	60007	70007	80007	90007	50007
10008	20008	30008	40008	60008	70008	80008	90008	50008
10009	20009	30009	40009	60009	70009	80009	90009	50009

<colgroup><col style="width: 48pt;" span="9" width="64">
<tbody>


</tbody>

 

[Andrew Poulsom]

How does your second table relate to the first?

 

[Toastis]

The second table is the series of serial numbers for each terminal. The top row is the terminal identifier and immediately under is the range of serial numbers available. If they can be built into the VBA code, that's wonderful. The beginning number is how we will associate them to the terminals. So WH 1 starts ALWAYS with 1, WH 2 starts ALWAYS with 2, the only one different is 10 which will start with 5.

Length of the serial number is immaterial.

 

[Andrew Poulsom]

I don't see any reference to terminal in your first table.

 

[Toastis]

Warehouse = Terminal in the first table - I haven't changed the headers. The terms are interchangeable.