Howdy. Brand new to the excel groups... Hope you'll forgive me. I'm
traditionally an Access user. My new employer doesn't have it and
isn't likely to get it. We have a situation that is very time
consuming and I'd like to hear the opinion of the experts. At my work
we basically scan barcodes from product into an excel spreadsheet.
After a long list of about 300 to 500, we are to check those barcodes
against an online database of reliable parts. Great, except that the
interface for that website will only allow the data from one barcode
at a time. Right now we must copy and paste each one. Very time
consuming. In Access, I could probably dream up a way to accomplish
this using VBA, and I'm sure the solution is similar in Excel, but I'm
not sure. Can anyone point me in the right direction?