Hi,

I have an excel spreadsheet as below in column and data in the corresponding columns:

1;2;3
2;3
2;3
1;2;3
2;3
2;3
2;3
2;3
1;2;3
2;3
1;2;3

I would like to write a macro to sort the data between "1;2;3" and then go to next search item and sort data and continue to do this until the last blank cell in a column. I would appreciate any help on this.

Thanks