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.
[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.