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?

 

[mddrexel]

mddrexel,

Welcome to the MrExcel forum. Thank you

1. What version of Excel, and, Windows are you using? we are using Excel 2010

2. Are you using a PC or a Mac? on a PC


Based on your description, screenshots will probably not work correctly.

To start off, and, so that we can get it right on the first try:

I would like to see your actual raw data workbook/worksheet(s). I'll try it

The following is a free site:

You can upload your workbook to (the BLUE link-->) Box Net ,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.

Thank You!

 

[mddrexel]

This is the link in Box https://m.box.com/view/36100310030

enter any value under GRINDER and hit enter, once the time and date appear can they be locked to keep them from being edited?

 

[hiker95]

mddrexel,

Your link to BOX is asking for an Email Address, and, a Password????

You can upload your workbook to (the BLUE link-->) Box Net ,

sensitive data changed

mark the workbook for sharing

and provide us with a link to your workbook.

 

[mddrexel]

I'm not sure what I am doing wrong here, the file is set to share without a password to anybody with the link, is there any other way I can share this with you?
it is small, only 18 kb

 

[hiker95]

I'm not sure what I am doing wrong here, the file is set to share without a password to anybody with the link, is there any other way I can share this with you?
it is small, only 18 kb

mddrexel,

Your link to BOX is still asking for an Email Address, and, a Password.

Can you try reposting your workbook?

 

[mddrexel]

https://app.box.com/s/1uomhuucivl93pstgop4g64btb7ha1bt

maybe this time

 

[hiker95]

mddrexel,

Thanks for the workbook.

I have found that some people have been changing the times to make it look like their entries were done at different times. is there any way to lock the time entries once they are made?

I have not been able to modify the Worksheet_Change event code to accomplish your latest request.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[mddrexel]

BUMP

Thanks for being so patient with me, I appreciate the help! if anybody else would like to give it a shot, please feel free.

mddrexel,

Thanks for the workbook.



I have not been able to modify the Worksheet_Change event code to accomplish your latest request.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[benkimya]

Hi

Thanks for your macro, this is ver useful for me.
But i want to stamp the date and time in different colums. How can i do it? Could you help me?

i add the screenshot of excel. i stamp the date and time Colum B and H

[/URL][/IMG]

 

[hiker95]

benkimya,

Welcome to the MrExcel forum.

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?

Thanks for your macro, this is ver useful for me.
But i want to stamp the date and time in different colums. How can i do it? Could you help me?

i add the screenshot of excel. i stamp the date and time Colum B and H

You have posted a screenshot as an IMG, that contains merged cells in the title row/rows.

3. What should the date and time format be for columns B, and, H?

When you add something to a cell in column A, the Worksheet Change Event will fill in the date and time in column B of the same row.

4. What cell, or range of cells, in the row, should trigger the date and time entry in column H?


I always like to test a macro with an actual workbook/worksheet, or screenshots (but, not IMG images).

With that said, and, so that I can get it right on the first try, can we see your actual raw data workbook/worksheet?

You can post your workbook/worksheets to the following free site (sensitive data changed), and provide us with a link to your workbook:

https://dropbox.com