Hi,
Thank you in advance. Not sure if anyone can help me. I will try and explain what I am after, I have been trying with vlookup but I think I might be barking up the wrong tree.
I have 5 different sizes of t shirts and 3 different colours, in total 15 barcodes.
I want to be able to scan a barcode which will take 1 off the inventory I have in stock.
for example
Black
Small 5
Medium 5
Large 5
X-Large 5
XX-Large 5
So if I scanned the barcode for the black small it would take the number down to 4. I can use the barcode scanner to put the number in a cell I select e.g A1 but after the scan I want it to take the number down to 4 and then clear cell 1 so I can scan another barcode.
Not sure if this makes sense.?
Thank you for your help
Kind Regards
James
Thank you in advance. Not sure if anyone can help me. I will try and explain what I am after, I have been trying with vlookup but I think I might be barking up the wrong tree.
I have 5 different sizes of t shirts and 3 different colours, in total 15 barcodes.
I want to be able to scan a barcode which will take 1 off the inventory I have in stock.
for example
Black
Small 5
Medium 5
Large 5
X-Large 5
XX-Large 5
So if I scanned the barcode for the black small it would take the number down to 4. I can use the barcode scanner to put the number in a cell I select e.g A1 but after the scan I want it to take the number down to 4 and then clear cell 1 so I can scan another barcode.
Not sure if this makes sense.?
Thank you for your help
Kind Regards
James