Hi, Good Evening.
I have a worksheet with 3 sheets named PASS, IN & OUT.
I'm currently searching for a VBA code that will help me in identifying what serial numbers are still unused by my teams.
Example:
In James' case, he has 2 unused item, so the VBA will help me enter the unused serial on BOX A column and the date it was withdraw.
Likewise, in Andrew's case, he has 1 unused item, so if I change the Lead name in PASS sheet then execute the code. VBA will help me enter the unused serial on BOX B column and the date it was withdraw.
We're having additional team lead so I'm thinking if Team Lead can be a variable?
Thanks in advance.
PASS:
Sheet IN
Table Name: IN
UNUSED Items
Sheet OUT
Table Name: OUT
USED Items
I have a worksheet with 3 sheets named PASS, IN & OUT.
I'm currently searching for a VBA code that will help me in identifying what serial numbers are still unused by my teams.
Example:
In James' case, he has 2 unused item, so the VBA will help me enter the unused serial on BOX A column and the date it was withdraw.
Likewise, in Andrew's case, he has 1 unused item, so if I change the Lead name in PASS sheet then execute the code. VBA will help me enter the unused serial on BOX B column and the date it was withdraw.
We're having additional team lead so I'm thinking if Team Lead can be a variable?
Thanks in advance.
PASS:
Sheet IN
Table Name: IN
UNUSED Items
Sheet OUT
Table Name: OUT
USED Items