Scan Barcode to excel for 3 times only

ygurram

New Member
Joined
Dec 4, 2017
Messages
14
Hi,
I am looking something similar to thread shown below.
https://www.mrexcel.com/forum/excel-questions/672492-scan-barcode-excel-date-time-stamp-out.html.

I am looking for the similar code that hiker has provided in his reply #18 but My way of arranging cells is little different and I need to scan a particular Part number for only 3 times. As you can see below Part number(which needs to be scanned is in D column and cell starts from D3). 1st, 10th & Last are in columns G,H & I( this is where I need time stamps when scanned 3 times)
JOBDoes Part Match spec. sheetDoes part # match label?Part NumberIs PPE required for Part Number?What is the Country of Origin1st10thLast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

<colgroup><col><col span="2"><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Hi,
I am looking something similar to thread shown below.
https://www.mrexcel.com/forum/excel-questions/672492-scan-barcode-excel-date-time-stamp-out.html.

I am looking for the similar code that hiker has provided in his reply #18 but My way of arranging cells is little different and I need to scan a particular Part number for only 3 times. As you can see below Part number(which needs to be scanned is in D column and cell starts from D3). 1st, 10th & Last are in columns G,H & I( this is where I need time stamps when scanned 3 times)
JOBDoes Part Match spec. sheetDoes part # match label?Part NumberIs PPE required for Part Number?What is the Country of Origin1st10thLast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

<tbody>
</tbody>

Here is the Excel format I am having. Please help
Heading
JobDoes PN match the sheetDoes PN match the labelIs PPE requiredwhat is country of origin Part Number1st 10th100th
1
2
3
4
5
6
7
8
9

<colgroup><col width="64" style="width:48pt" span="9"> </colgroup><tbody>
</tbody>
 
Upvote 0
Heading
JobDoes PN match the sheetDoes PN match the labelIs PPE requiredwhat is country of origin Part Number1st 10th100th
1
2
3
4
5
6
7
8
9

<colgroup><col width="64" style="width:48pt" span="9"> </colgroup><tbody>
</tbody>
 
Upvote 0
ygurram has exceeded their stored private messages quota and cannot accept further messages until they clear some space.

ygurram,

No more Private Messages......

I have attempted to reply to you on two occasions, but, you have reached your quota (per the above).
 
Upvote 0
ygurram,

So that I can get it right on the first try, I would like to see your actual raw data workbook/worksheets, with the raw data in one worksheet, and, in another worksheet (manually formatted by you) the results that you are looking for.

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

https://dropbox.com
 
Upvote 0
ygurram,

So that I can get it right on the first try, I would like to see your actual raw data workbook/worksheets, with the raw data in one worksheet, and, in another worksheet (manually formatted by you) the results that you are looking for.

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

https://dropbox.com

Hiker95,
I have attached my workbook in dropbox. Please see below link for excel worked/ I have modified the format again.

https://www.dropbox.com/s/bmk0gh6n3qbu9zf/Book1.xlsx?dl=0

As you can see my C3 will be my active cell for barcode scanning under Part Number. Your code given in reply #18 from below thread worked perfectly fine but I need the barcode to be scanned 3 times only for each part number, in other words I need only 3 time stamps for a particular part number in a row that will be in Column D,E & F. Can you also please add a code for autosave?
https://www.mrexcel.com/forum/excel-questions/672492-scan-barcode-excel-date-time-stamp-out.html

One more thing, Is it possible to avoid Manual entry for Column C,D,E & F. so that data can inputted in column C is through barcode only.

Thanks in Advance!

Ygurram.
 
Upvote 0
I have attached my workbook in dropbox. Please see below link for excel worked/ I have modified the format again.

As you can see my C3 will be my active cell for barcode scanning under Part Number.

ygurram,

That will not work based on the macro you have a link to.

Can we use cell C1 to scan ALL the barcodes into?


If we scan barcode 12345678AA into cell C1, then the new macro will search from C2 down to see if the barcode already exists.

If it does on not exist, then, it will add it to cell C3, and, put the date/time/stamp into cell D3.

Then we clear cell C1.

If we scan barcode 12345678AA into cell C1 again, the macro will search from C2 down, and, it will find the barcode in cell C3, and, then it will check row 3 for the next blank cell, D3, and, put the date/time/stamp into cell E3.


If we scan barcode 12345678BB into cell C1, then the new macro will search from C2 down to see if the barcode already exists.

If it does not exist, then, it will add it to cell C4, and, put the date/time/stamp into cell D4......

Then we clear cell C1, and, wait for the next barcode.


I hope that you can understand the above logic.

If you do, is what I have explained acceptable to you?


If not, then maybe someone else on MrExcel will be able to solve your request.
 
Upvote 0
Good day Hiker,

Sorry for the late response I was busy in figuring out what format I need to use.

I have updated my Macro with final format. Please see below link.
https://www.dropbox.com/s/xrq4xou2xihicir/VALD TRAIL.xlsm?dl=0

Let me explain you better what I am looking for. The idea is to scan a particular part number at least 3 times and to avoid same part number being scanned twice. I have used Data validation with formula =COUNTIF($B$1:$B$100,B1)=1 to address this issue prevent duplicates. If you try entering same Partnumber in column B it will give me alert which is exactly what I am looking for to alert the operators.

Operator selects B4 to scan 12345678AA and I am looking for time stamps in format 12345678AA(part number), HH:MM starting from Column L.

Everytime they need to scan a barcode they would need to select the active cell. Suppose if they want scan the part number 12345678AB they will select B5 and B6 for 12345678AC.


Would it possible to have the time stamp along with part number when scanned?

Thanks in advance!

Yashwanth
 
Upvote 0
ygurram,

I have had problems in the past when attempting to download an Excel file with macros, with the xlsm file extension.

Please remove all macros, and, then rename the workbook using the xlsx file extension, and, then repost on dropbox.


Then in your next reply, also include your macro:

When posting VBA code, please use Code Tags - like this:

[code=rich]

'Paste your code here.

[/code]
 
Upvote 0

Forum statistics

Threads
1,213,529
Messages
6,114,155
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top