Can someone please help me create 2 input for a check in/out system

[suicidalporcupine]

Can someone help me with a vba with input button - where an employee can enter their ID#, press Next, Enter the Item/Barcode#.

for each item they enter, Excel will compare it to Column A, and change the Column F(Location) to the associated name of ID#

[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD]Barcode[/TD]
[TD]Case Name[/TD]
[TD]Property[/TD]
[TD]Email[/TD]
[TD]Date[/TD]
[TD]Location[/TD]
[/TR]
[TR]
[TD]123001[/TD]
[TD]Ernie v. Burt[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Andrew[/TD]
[/TR]
[TR]
[TD]123002[/TD]
[TD]Marvels v. DCU[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Daniel[/TD]
[/TR]
[TR]
[TD]123003[/TD]
[TD]Taco v. Burger[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Cathy[/TD]
[/TR]
[TR]
[TD]123004[/TD]
[TD]Mary v. Jane[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Gina[/TD]
[/TR]
</tbody>[/TABLE]


or show me a link wwith similar or existing situation where I can get started