hi i used the formula and it didnt work for me what should i do im pretty sure i used the right formula it is what you had in the picture but it would be easier if we could just copy and paste off of the page either way here is what i used from the image above =if(b1"",IF(a1="",now(),a1),"")
Great video . Is it possible (after adedd barcodes to excel) that when we scan a product excel will mark the cell with that barcode? Like sales in shop , you scan and name of product pop up.
Hello, when I input the formula, it words however, when I input another item on the B2 for example, the A1 also changes to the current date and time. How will the date and time entered in A1 stay as is?
Thank you this is very helpful for what I want to do. I changed the date / time column to Column B and am using Column A for the bar code data (actually I'm using magnetic stripe and mag card reader.) I tired to put column headings Member and Date_Time in Columns A and B but when I scan the bar code into column A the time and date are entered on the line below in Column B instead of on the same line. Any ideas?
Hello, any changes to where column data will be input could cause other unintended changes. Also, you are using a barcode slot reader, which could be causing this? Test the settings of your barcode slot reader by scanning into Excel, with no formula, if the scanned data is input where it should be, then the setting of the barcode slot reader is OK, if the scanned data is still input into the line below, then you will need to change the barcode slot reader’s settings. If you can scan into Excel OK with no formula, then then the problem could be the formula if you have changed anything that was shown in the tutorial.
I entered in the code and it does nothing form me. It gives me a #NAME? error. Additionally, is there a way to associate each bar code to a name in the adjacent cell? so it would read, date/time, name, badge number (which is what the bar code is). I know how to attach fields to a tab at the bottom, is there a way to make a tab pop up with a scan or move to the front of the order?
can you help me, i need to scan barcode to two documents at the same time i created 2 Excel workbooks the first one is : Daily Record and the second is : Invoice Record what i want to do is : when i scan a barcode to a specific column in the first workbook , the barcode No. will also goes/auto copy to specific column in the second workbook. Please Help i need an idea on how to do this
I spent a few hours looking for this information and was just about ready to give up. This is exactly what I was hoping to find - thank you very much!
Thank you so much! This was SO HELPFUL (even three years later).
Thank you it helps me a lot with the attendance system that i am preparing for the school
how to stop duplicates , i mean what if the he comes again and shows his barcode?
any syntax for that, or any error message that displays ?
hi i used the formula and it didnt work for me what should i do im pretty sure i used the right formula it is what you had in the picture but it would be easier if we could just copy and paste off of the page either way here is what i used from the image above
=if(b1"",IF(a1="",now(),a1),"")
Great video . Is it possible (after adedd barcodes to excel) that when we scan a product excel will mark the cell with that barcode? Like sales in shop , you scan and name of product pop up.
Thanks a bunch, tips are really useful
Hello, when I input the formula, it words however, when I input another item on the B2 for example, the A1 also changes to the current date and time. How will the date and time entered in A1 stay as is?
how to stop duplicates , i mean what if the he comes again and shows his barcode?
any syntax for that, or any error message that displays ?
Do you have a video for scanning tickets at the entrance of an event? So I can see if a ticket is valid, unvalid, or already scanned...?
Hello, can you show us how did you connect the scanner to your laptop?
Is there a way to create a function that "clocks out"? Like every other scan for a particular barcode would be a sign in/sign out
That could be done but you would need to write a new macro for Excel to perform that function.
how to record "out timestamp" in the same line of the name?
pls tell me what information does the barcode of student id contains?
Thank you this is very helpful for what I want to do.
I changed the date / time column to Column B and am using Column A for the
bar code data (actually I'm using magnetic stripe and mag card reader.)
I tired to put column headings Member and Date_Time in Columns A and B but
when I scan the bar code into column A the time and date are entered on the
line below in Column B instead of on the same line. Any ideas?
Hello, any changes to where column data will be input could cause other unintended changes. Also, you are using a barcode slot reader, which could be causing this? Test the settings of your barcode slot reader by scanning into Excel, with no formula, if the scanned data is input where it should be, then the setting of the barcode slot reader is OK, if the scanned data is still input into the line below, then you will need to change the barcode slot reader’s settings. If you can scan into Excel OK with no formula, then then the problem could be the formula if you have changed anything that was shown in the tutorial.
I entered in the code and it does nothing form me. It gives me a #NAME? error. Additionally, is there a way to associate each bar code to a name in the adjacent cell? so it would read, date/time, name, badge number (which is what the bar code is). I know how to attach fields to a tab at the bottom, is there a way to make a tab pop up with a scan or move to the front of the order?
thanks a lot , so helpful
How can I do this with remote scanner to send SMS with different locations
How can I do this for QR code? And multiple entry in to same row?
please tell how to include the timeout function as well......
I hope that has been figured out.....
Thanks sssssssssooooo much
can you help me, i need to scan barcode to two documents at the same time
i created 2 Excel workbooks the first one is : Daily Record and the second is : Invoice Record
what i want to do is : when i scan a barcode to a specific column in the first workbook ,
the barcode No. will also goes/auto copy to specific column in the second workbook.
Please Help i need an idea on how to do this
Hello, unfortunately we do not know of any solution we have tested that would allow you to perfrom that function.
thanks for your help
You saved my life
Great to hear this video tutorial helped you. Be sure to view our other vidoes for more point of sale related topics.
in column A it says #NAME? why is it not displaying time? excel 2016
Please post the formula 🙏🏾
I cannot see the formula
can't generate the real time Sad