My coworker wants to create an invoice template in Excel 2007. In column 1, he wants to be able to put in a SKU like '000293954', and when he hits tab, have the other columns fill in a matching description and price. There would be a bunch of different SKUs and information.
Has anybody done this type of thing with a macro before? Any advice?
 The input wouldn't be typed - he'd use a wedge barcode scanner that inputs just like it was typed. Not that it matters for this question.