NEWB needs help sorting data

[importriders]

Still teaching myself VBA but I have a problem and have no idea how to tackle it.

I have a bunch of 3D coordinate (X,Y,Z) barcodes scanned into excel and need them sorted into specific columns based on the direction represented by the first letter (X,Y,Z) in the barcode. A set of data has an X, Y, Z coordinate and is bookmarked by "END" scans.The scans come in like below and the user can scan in any order as long as he bookmarks each data set with an "END" scan.

X1234

Y3242

Z2342

END

Z6546

X654

Y5435

END

Y6544

X65445

Z5335

END

I need a macro that can sort the scans into this format:

X1234	Y3242	Z2342
X654	Y5435	Z6546
X65445	Y6544	Z5335

Any help would be much appreciated. Thanks in advance.

[Nu2Java]

Are you trying to scan the parts and have them go to the right? Or you just need to sort them this way after they are scanned? Are you using any kind of input form? Or straight into the sheet?

[shg]

If you set the Move after enter direction to right, lock all but the first four columns, and then protect the worksheet, it should scan in exactly in that fashion (with the End values appearing in col D).

[importriders]

The sheet is already populated so I just need a macro that sorts the sheet.

[importriders]

If you set the Move after enter direction to right, lock all but the first four columns, and then protect the worksheet, it should scan in exactly in that fashion (with the End values appearing in col D).

The barcodes are batch scanned and downloaded. The program that came with the scanner downloads the scans in one column. I don't have any way to change the format it downloads.

[importriders]

I should clarify I want the user to be able to scan XYZ in any order.

For the sorted data it will be a collection of nodes. Node being an XYZ coordinate data set. Each row represents a NODE with the corresponding XYZ columns in that order. Hope that makes sense.

I added the END barcode to separate the different nodes or else it would just be a list of XYZ.

[importriders]

Anyone have any ideas?

[shg]

Maybe ...

Please Login or Register  to view this content.

[importriders]

Thanks this worked out great!

[shg]

You're welcome.