Hi there ,
I need a simple solution to get me started on this task.
I want to scan 12 widgets that have 4 pieces of information.
Each piece is separated by a space in the scan and after the last piece there is a carriage return.
Batch#: (which is a 8 digit number)
Lot #: which is one letter and 4 numbers ( J1234 )
Date: 10OCT2015 ( DDMMMYYYY )
Widget # ( up to 500 )
On one scan all this data populates the first active cell in excel, I would like the data to separate into each cell in next column.
Then when the last scan is complete which normally is 12 skids, but could be less, it would be sent to printer to generate a trip report.
Thanks so much.
Should be fun.