I'm exploring the option of using excel to keep track of a small church library (<500 books/DVDs). I already have a barcode scanner, and I know that if I scan a barcode while my cursor is in a cell it will generate a series of numbers.... basically read the barcode. So I'm confident that I can scan a book or DVD's barcode to begin creating a library database.
Here's my question: After I've completed scanning in barcodes and creating a database, is there a formula or something I can use to program the excel spreadsheet so that it will find the item I am looking for when scanning a barcode? Basically... can i program it to function like library automation software? I want to be able to scan a barcode to find that book or DVD within in the database I've created so that I can record check in/out dates & information. Anyone know how to do this???
Thanks for any help/advice you can give!
Bookmarks