Re: Scan Barcode to excel for 3 times only
Quote:
Originally Posted by
ygurram
ygurram,
You have changed the worksheet format/layout several times.
And, now you do not want a macro???
I have examined your latest workbook, and, do not understand what you are trying to accomplish.
Maybe someone else on MrExcel will be able to help you.
Re: Scan Barcode to excel for 3 times only
Hiker,
Sorry to confuse you by changing the format/layout multiple times. I had to figure out what would be the best format to use.
I indeed want a macro but I don't have one. I want you to help me please.
As you can see in workbook Column 2 will be used for scanning the bar-code starting from B4.
Lets assume part number 12345678AA is scanned by selecting B4 manually at 12:01, once scanned I need both 12345678AA and time in target row starting from L4. After 1st scan, operator selects B4 again to scan 12345678AA at 12:30 and both 12345678AA will be in M4 . After 2nd scan, operator selects B4 again to scan 12345678AA at 13:0) and both 12345678AA will be in N4. Suppose operator selects B4 again to scan 12345678BA at 13:01 and both 12345678BA and 13:01 will be in O4.
Everytime they scan in it should add scanned part number and time stamp starting from column L.
Same applies for part number 12345678AB/AC/AD.....
Hope this clears!
Ygurram.
Re: Scan Barcode to excel for 3 times only
Hiker,
Does this makes sense?
Yashwanth
Re: Scan Barcode to excel for 3 times only
ygurram,
When I started adding a macro to your latest workbook, and, tried to save it, I received the following message:
Microsoft Office Excel
Privacy warning: This document contains secured ActiveX controls, XML expansion pack information, or web components. These may include personal information that cannot be removed by the Document Inspector.
OK Cancel
Someone else on MrExcel will have to help you.
Re: Scan Barcode to excel for 3 times only
ygurram,
I downloaded your last workbook again, and, copied Sheet1 into a new workbook.
The Job Numbers in column A, beginning in cell A4 = 1, how far do the numbers go down?
Re: Scan Barcode to excel for 3 times only
Hiker,
Sorry. I must have uploaded excel file from my work laptop.
The Job Numbers can go down to 500 starting from A4.
Thanks in advance.
Ygurram.
Re: Scan Barcode to excel for 3 times only
ygurram,
I am not able to provide a macro solution in this thread.
Please see your other thread for a macro solution in this thread.
Re: Scan Barcode to excel for 3 times only
Hiker,
I couldn't see the macro code in my other thread.
ygurram
Re: Scan Barcode to excel for 3 times only
ygurram,
On both of your threads/posts, I have clicked on the Report button, but, none of the Administrator's have corrected the problem.
Re: Scan Barcode to excel for 3 times only
Good morning Hiker,
I am new to Mr.Excel. Do I need to start a new thread or can I share my email ID here so that you send the code?
Please advise.
ygurram