Hello:
Please refer to attached file.
Need VB Code to do the following.
I will have data in column B as example shown.
I need to organize this data in column C and D as follows
1st split the text in cell B6:B18 in column C and D.
Example:
C6 will become 30003 and D6 will become S-Chocolate
C7 will become 30005 and D7 will become S-Strawberry
and so on.
Now i need data in cells C6: D18 re-arrange with number in column C will be ascending order in list.
So
C6 will be 10012 and D6 will be S-Shake
C7 will be 30003 and D6 will be S-Chocolate
and so on..
Let me know if you have any questions.
Thanks.
Riz
Bookmarks