Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hello Richard. A short sample of what we're working with is under File ID #445524. When we scan the equip, the barcode is set in column A in random order. We would like them to appear beside their match in column B.
Thanks in advance.
Yes the numbers should match. We scan the bar codes on the equip (equip bar code; equip descript). The scanner drops the numbers in column A. We would like the column A numbers to find their 'match' in column B.
This would not let us know if the equipment is still on the truck.
How do I access the file Richard? Sorry, I've never been to this site. Do I use the wikisend link? Also, what you did for us with this file, can we copy something and apply it to our other spreadsheets?
This works extremely well Richard. Is it possible to place the run command elsewhere? Column D is used to indicate the location of the equipment. An example is at file 106182. Excellent service btw.