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?
<tbody>
</tbody><colgroup><col><col><col></colgroup>
<colgroup><col style="width: 48pt;" span="9" width="64">
<tbody>
</tbody>
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>