QR Code - Product code

[Honor Daniels King]

Hi Everyone,

Please could you help me.

I have created a consumable list using QR codes (scan it to office) with stock in and stock out.

When I scan the QR code it imports the product code into the sheet that i have open (stock in or out). However at the moment I have to scan the item multiple times to give the correct quantity. On the scan it to office app it allows me to add the correct quantity but it is not getting picked up on the main sheet as the product code is only on the sheet once.

Hope this makes sense.

Thank you!!

 

[psycoperl]

I am not sure I am understanding what it is that you are looking for with with?

Also, when cutting and pasting from Excel into the message board, using XL2BB (see the button on the formatting bar) is the best way as it would allow us to see the formula behind the scenes along with having the display formatted like Excel.

 

[Honor Daniels King]

Hi there,

Thank you for your reply.

So I have shown two examples.

First example, In the first image the product code MI-GLONITHD-L, I have scanned the QR code ten times to give me the correct quantity on the main page (image 2). I am using the count if formula (counting the product code).

Second example, Product Code: XCP-ONE-400. I have scanned the QR code once but I have manually put in the quantity of two. However the quantity is not pulled through to the main sheet as the countif formula is only picking up the product code once.

Is there a way I can get the product code to be multiplied by the quantity and then the countif formula would work?

Swanwick consuamble check in and out.xlsm
	C	D	E	F	G	H	I	J	K	L	M	N
7	Nitrile Heavy Duty Gloves - BLACK HEAVY DUTY NITRILE GLOVES LARGE PK50	LARGE	Pack of 50	MI-GLONITHD-L			10	0	10	4	$12.55	$125.50
8	XCP One - XCP ONE HIGH PERFORMANCE MULTIPURPOSE SPRAY 400ML	400ml	1	XCP-ONE-400			1	0	1	2	$2.55	$2.55
Consuambles

Cell Formulas
Range	Formula
I7:I8	I7	=COUNTIF('SWK Inventory Check-in'!$A$2:$Z$999995,Consuambles!F7)
J7:J8	J7	=COUNTIF('SWK Inventory Check-out'!$A$2:$Z$999996,Consuambles!F7)
K7:K8	K7	=I7-J7+H7
N7:N8	N7	=K7*M7

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
K7:K14	Other Type	Color scale		NO
K7:K14	Other Type	Color scale		NO

Swanwick consuamble check in and out.xlsm
	A	B	C	D
1	Product ID
2
3	Product ID	Quanity	Job Number	Name
4	MI-GLONITHD-L	1
5	MI-GLONITHD-L	1
6	MI-GLONITHD-L	1
7	MI-GLONITHD-L	1
8	MI-GLONITHD-L	1
9	MI-GLONITHD-L	1
10	MI-GLONITHD-L	1
11	MI-GLONITHD-L	1
12	MI-GLONITHD-L	1
13	MI-GLONITHD-L	1
14
15	XCP-ONE-400	2
SWK Inventory Check-in