hi guys, need your help how to achieve this thing.. basically i got about thousand cells.. so here's the case: my data look like this in a single column
what i want is to sort this thing to a different columns like: U*** DATA wil be in a single column, J*** DATA will be in another column also.. Y*** DATA also another column..
how to do this in VBA? any help is greatly appreciated.. if a bit confusing pls. ask.. thanks in advance..
U100
U101
U102
U103
J101
J102
J103
Y101
Y102
Y103
R101
R102
R103
S100
S101
S103
what i want to do is basically like this: each got each own column.
U COLUMN J COLUMN Y COLUMN R COLUMN S COLUMN
U*** J*** Y*** R*** S***
U*** J*** Y*** R*** S***