barcode scanning

I have a sheet that I use to track job time using a simple barcode scan that time stamps the scan in and out. I am looking to add more information to the job for tracking but don't want to do multiple scans if it's not required.
How can I take l following example of barcode text and have it go into separate cells with one scan.
Thanks

25478 Smith 55
three separate columns one barcode

Hi,

Perhaps a Sheet Change event macro that reacts to the scanner populating a cell or cells on the sheet. The macro should parse the string you show into three columns.

thanks Richard.
This is the code i am running now. How wold it interfere or would it?

Please Login or Register  to view this content.

I need to understand the current process a little more,

Are you saying that the 3 element string you mention in post#1 is currently arriving in column 1 as a Start Scan and if the scan is a stop scan this goes into column 5, and the macro is then adding the date & time to columns 2 & 3, and that the requirement is to split the 3 element string to three separate columns?

It would be useful if you could upload the workbook with some example scan detail rows showing different values (and permutations of entries if that's at all relevant), and then manually add the results you expect to see after some new code parses the string. I see the new code as an addition to the existing macro but need to understand which of the IF..End If blocks of code should be the trigger.

I have attached the workbook. I have used the austin tab to show how I would like the results to now appear breaking a single scan into three cells

sorry this site is messed i keep getting kicked off before upload completes i will try later

try this time

works perfect thanks

sorry nosparks is there an option for the last section of the three in the scan to be formatted as a number. Its formatting as text now and if i try to format the cells prior to to data transfer it just switches it back. I need to average out that last column
thanks

Originally Posted by NoSparks

No need to be sorry.
Every project undergoes revisions.

See if this works as needed.
Code is only with the Austin sheet.

Looking at your 'Data' sheet, the client name/number are not always in the same order and I assume the end number is yet to be inserted in the bar codes.
Are LUNCH, BREAK and YARD typed in manually?

Good Luck

YARD, BREAK & LUNCH are scanned as well. I have corrected the order issue so all future scans will be invoice number, client surname, sq footage. It's the sq'# that i needed to do calculations on. New code seems to woork ok. My old scans only have two and there are a few of those to go through the system. So far this morning those old ones are placing # in cell b2 and b4. we'll see how that plays out at end of day when i transfer data.

deleted my post