title: Excel Barcode Scanning Macro
body: <p>I deal with a large number of unique products (10,000+ per year on my own) and I am looking to optimise Excel to make my job more efficient. I have a USB barcode scanner and want to implement this into my process.  </p>
  
  <p>My suppliers send me a large spreadsheet with product info, such as barcode number and other product details. I also recieve samples of the product and need to register them within the system, and cross reference them with the spreadsheet.</p>
  
  <p>I am looking for a macro which: when it recieves an input from the scanner, searches and navigates within the spreadsheet to the row where the product is, and if the same barcode has a second scan within 3-5 seconds, fills in the date in column x, and if column x is an occupied cell, fills in the date in column y.   </p>
  
  <p>This will allow me to both search for the product without filling in the date (not double scanning) for general lookups, but also to check the product in and out with the date.</p>
  
  <p>Thank you so much in advance for your help!</p>