How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Pete Your Own Question

Pete
Pete, Computer Expert
Category: Microsoft Office
Satisfied Customers: 15772
Experience:  MS Office expert
30970729
Type Your Microsoft Office Question Here...
Pete is online now
A new question is answered every 9 seconds

We are doing a store wide inventory using excel to collect

Customer Question

Hello,
We are doing a store wide inventory using excel to collect data from an advanced Intermec CN3 Barcode reader. When we can in a barcode number I would like excel to pull the quantity scanned and the product name from the data in the barcode. How can we program excel to do this with each scan?
Hannah ***@******.***
Submitted: 10 months ago.
Category: Microsoft Office
Expert:  Pete replied 10 months ago.

Hi Hannah,

If you have the data available then it can be pulled in using a VLOOKUP formula.

You can attach the spreadsheet here and I can set up the formula for you, or I can assist remotely.

Pete.

Customer: replied 10 months ago.
Hello, thank you for responding, I found another solution where all info is created from the bar code except for count, Then I formatted the count cell to never be less than one, which fixes my problem.You can close this work ticket.
Expert:  Pete replied 10 months ago.

Ok, glad to hear you got it sorted.

Have a great weekend!

Pete.