Hi,
I've the following sorted data in Excel (with the built in sort function).
0216AA
0216AA
0216AA
0216AA
0216AA
0216AA
0225BB
0225BB
0225BB
09036-0216AA
09036-0216AA
09036-0216AA
09036-0216AA
09036-0216AA
The numbers represents products. The problem is that 0216AA and 09036-216AA are the same products. So after 0216AA have to come 09036-0216AA. How can I do this sort automatically instead of manually copy and paste.
Is it possible using VBA?
Bookmarks