how to change 1 line of data to multiple rows

D

Daniel M

I have a macro that formats column data and imports it into an access
database. The data is scanned in with a barcode scanner. The problem is i
have to hit enter in between each item. All items are the same length. I
would like to see if i can format the data in a row to a column with a macro
after entry.

ie: All data in A1 =
02-00123402-12345602-845645
where all number are 02-xxxxxx then repeats with the next item.

I would like the data to be as follows:
A1 02-001234
A2 02-123456
A3 02-845645
where the data is in column A rows 1-3.

Any ideas? Thanks.
 
D

Daniel M

Nope, this doesnt work. It will work for going from columns to rows but not
the other way around. it doesnt know how long the data is to break it apart.
Any other ideas?

dm.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to change 1 line of data to multiple rows again... 1
Using VBA to create charts 1
Auto Detect Data, Auto Print Data, Auto Erase Data Loop 8
fixed column data 1
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
convert columns to rows 6
Autofil on variable rows, delete extract and show remaining rows 3
how to do a bulk submit? 2

Top