Formula to link barcode scanner result to nominal roll

weixun321

New Member
Joined
Oct 18, 2016
Messages
3
Basically I have several spreadsheets with list of guests that will be attending a event.
[TABLE="width: 500"]
<tbody>[TR]
[TD]IDENTIFICATION NO.[/TD]
[TD]NAME[/TD]
[TD]ATTENDING?[/TD]
[TD]REGISTERED?[/TD]
[TD]TIMESTAMP[/TD]
[/TR]
[TR]
[TD][TABLE="width: 105"]
<colgroup><col></colgroup><tbody>[TR]
[TD]A1234567B[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][TABLE="width: 72"]
<colgroup><col></colgroup><tbody>[TR]
[TD]JOHN SMITH[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD]YES[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 105"]
<colgroup><col></colgroup><tbody>[TR]
[TD]A7514812G[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD][TABLE="width: 72"]
<colgroup><col></colgroup><tbody>[TR]
[TD]JAMES BOND[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD]NO[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


We have a barcode scanner that is able to read the identification no. and the current method we are using to track the registration is to use CTRL+F, scan the barcode which give the identification no. result, then find all and then go to the registered column to put yes and fill up the timestamp.

However this method can be quite time consuming especially with the no. of guests we are handling.

I have an idea on working around this issue but am not sure if it is workable or how to do it in the first place.

Idea: have another spreadsheet created with the purpose to just scan the barcode.
[TABLE="width: 500"]
<tbody>[TR]
[TD]identification no.[/TD]
[TD]Timestamp[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

So all we have to do is to scan the barcode in that sheet, a timestamp will be created, and perhaps vlookup the result such that it will automatically find the guest and mark him as registered with timestamp on the other column. Then to scan the next person, we just have to press down arrow to another empty cell.

Really hope this idea is feasible and if someone could assist in the creation. Would like to avoid using VBA if possible though as the computer used for registration are quite highly secured that vba tend to not work? due to security issues.
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Forum statistics

Threads
1,223,228
Messages
6,170,875
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top