Scan barcode to excel with date & time stamp in & out.

[qpywsqp]

Hi all. I have research around the internet and finally found out Macro able to solve my issue. But im totally not a programmer. Hopefully someone can help me on this.

I will scan QR Code with a scanner to cell A1 and wanted cell C1 to have date and time stamp for IN. When Scanner scan the same QR Code, D1 will have date and time stamp for out. If repeat third time scanning the same QR code after a few scanning, it will appear on next row. Which means A8 with the code and C8 with date and time stamp for IN again.

Is that possible to done with Macro?

 

[hiker95]

dotco,

Welcome to the MrExcel forum.

It is always easier to help and test possible solutions if we could work with your actual file. Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do referring to specific cells and worksheets. If the workbook contains confidential information, you could replace it with generic data.

 

[dotco]

Hi hikers95,

Thanks for the feedback, i recently upload the file sample in this link : https://www.dropbox.com/s/9bfufoma2okhnfr/picking time record.xlsx?dl=0

just like this tread starter i would like to record each time in and out from person who take pick job.
when a person taking task their name tag will be scanned and excel will record their name into A2 and time start in C2.
after their tack complete the second scanned will record the time into D2. and operator will input manual the QTY in E2.
and after the time out recorded. the 3rd scan will record same procedure but will be write down to A3 or A4. with the same name. will be same with other person,
after time in and time out recorded the next scan will start all over again to below column name.

sorry for bad english.. im hoping your help. thank you

 

[hiker95]

dotco,

Your link is asking me to Sign in?

Maybe someone else on MrExcel will be able to help you.

 

[dotco]

Hi hiker95,

actually i don't have any file yet, but the output will just like image below.

[/URL][/IMG]

thanks

 

[hiker95]

actually i don't have any file yet, but the output will just like image below.

dotco,

I do not understand what you are trying to accomplish based on your image reply.

Maybe someone else on MrExcel will be able to help you.

 

[dotco]

hiker95,

finally found the solution....


Thanks,

 

[hiker95]

hiker95,

finally found the solution....


Thanks,

dotco,

Thanks for the update, and, I am glad that you found a solution.

 

[eumerl]

Hi Hiker95,

I would like to ask if it is possible that if the employee is absent a certain date it will jump. the next day he/she will go to work.

[TABLE="width: 1044"]
<colgroup><col><col><col span="6"></colgroup><tbody>[TR]
[TD]ID NUMBER[/TD]
[TD]NAME[/TD]
[TD="colspan: 2"]12-Sep-19[/TD]
[TD="colspan: 2"]13-Sep-19[/TD]
[TD="colspan: 2"]14-Sep-19[/TD]
[/TR]
[TR]
[TD]TIME IN[/TD]
[TD]TIME OUT[/TD]
[TD]TIME IN[/TD]
[TD]TIME OUT[/TD]
[TD]TIME IN[/TD]
[TD]TIME OUT[/TD]
[/TR]
[TR]
[TD]JTP006180007[/TD]
[TD]EUMERL ESPINA[/TD]
[TD="align: right"]2019-09-12 18:34[/TD]
[TD="align: right"]2019-09-12 18:34[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2019-09-14 18:34[/TD]
[TD="align: right"]2019-09-14 18:34[/TD]
[/TR]
[TR]
[TD]JTP006190179[/TD]
[TD]KRIZZA ANGELICA ROSALES[/TD]
[TD="align: right"]2019-09-12 18:34[/TD]
[TD="align: right"]2019-09-12 18:34[/TD]
[TD="align: right"]2019-09-13 18:34[/TD]
[TD="align: right"]2019-09-13 18:34[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]