Barcodes & stocktake

C

carrieann

G'day - I have been able to export a stock list from MYOB Retail Basics into
an excel spreadsheet. What I wish to do is scan stock items and have the
spreadsheet find the item in the stock list then I would manually add the
amount of stock in another column for stocktaking purposes. Can this be done
with just excel software?
 
C

cht13er

G'day - I have been able to export a stock list from MYOB Retail Basics into
an excel spreadsheet. What I wish to do is scan stock items and have the
spreadsheet find the item in the stock list then I would manually add the
amount of stock in another column for stocktaking purposes. Can this be done
with just excel software?

Yes, it can be done with just excel. How are you "scanning" stock
items to get the barcode into excel??

Chris
 
T

Thomas Lutz

There is an Excel "inventory" example spreadsheet that you can
download from the following web page:

http://www.taltech.com/freesoftware/Inventory.htm

The file that you download is an Excel workbook that contains a
special VBA coded "lookup" function that will search down column A in
the workbook looking for a number that you can enter either with a bar
code scanner or on the keyboard and if it finds a match, it will
highlight the row containing the matching number and allow you to
increment or decrement a quantity value. You should be able
to use it to do exactly what you want to do.
 
C

carrieann

A stock list from MYOB Retail Basics has been downloaded into an excel
spreadsheet. When using "Find & Select" in excel it won't recongnise the
product when scanned, however, if you manually type the code in it is
recognised.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quick/efficient way to VBA subtotal 2
Newbie Help 0
Lookup Macro 5
Import a CSV file HELP 1
Conditional Statements 3
Is VLOOKUP what I need? 3
Upload range into an array 1
sorting data 0

Top