Is it possible to change the target cell's value (Value A)base on another value (Value X)entered?

[suicidalporcupine]

Can someone please help me on this or at least show me the link on how to get started?

I am thinking of going paperless with check in and check out through excel + barcode scanner. So right now I have a master list of all the cases we have in the office.

My idea is to first type in their name which will become Value X(Andrew), then they will scan the barcode (located on the folder) Excel will search in column A and determine that the scanned barcode matches with the barcode located in A2(example), Excel will then change the cell F2 value to the name of the person.

[From the understanding, whenever you have excel sheet open. and whenever you scan the barcode, excel will enter it as if you typed the set of numbers yourself].

[TABLE="class: 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]B. Bird v. Trasher[/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][/TD]
[/TR]
[TR]
[TD]123004[/TD]
[TD]Mary v. Jane[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Gina[/TD]
[/TR]
</tbody>[/TABLE]

 

[jmacleary]

Hi there.
The way I would go on this is to create a simple form activated with a button on your worksheet which has 2 input fields. First field will have the name input (why not give each person a card with their name as a barcode so they dont have to type it - avoids errors and increases consistency). The second field will then have the barcode scanned in. You can create some very simple code behind the form so that once both fields are populated, you can find the barcode in column A and populate column F on the same line. If you need help with this get back to me and I will put something together, but it may take a while.

Regards
John

 

[suicidalporcupine]

Thanks that is a more doable idea.

Can the 2 input have 1 entry for the name, Barcode/keyboard in case they say they forgot the ID, and then for 2nd entry will have the option continually scan for more items, and select Finish when they are done.

but then what if the same person decide to return the item(s) can excel remove the name, if the barcode and name match?

1. Scan Name
2. Scan item,
- if Column F is blank, add Scanned name.
- if Column F matches scanned name, remove same name.
3. Select Finish/Complete to Exit

 

[suicidalporcupine]

Hi there.
The way I would go on this is to create a simple form activated with a button on your worksheet which has 2 input fields. First field will have the name input (why not give each person a card with their name as a barcode so they dont have to type it - avoids errors and increases consistency). The second field will then have the barcode scanned in. You can create some very simple code behind the form so that once both fields are populated, you can find the barcode in column A and populate column F on the same line. If you need help with this get back to me and I will put something together, but it may take a while.

Regards
John

Yes please help me