Forum Discussion
Gerry2020
Dec 08, 2020Copper Contributor
Sorting numbers in one cell while keeping attached text to it in another cell
Raw data scanned into inventory in column A where Inventory numbers in Cells 1,3,6 have to be sorted numerically from smallest to largest while keeping attached serial numbers in Cells 2,4,6 to the s...
Gerry2020
Dec 08, 2020Copper Contributor
HansVogelaar well that looks complex but I'll try it out. Thanks for the solution.
HansVogelaar
Dec 08, 2020MVP
You don't really have to understand the code.
Press Alt+F11 to activate the Visual Basic Editor.
Select Insert > Module.
Copy the code from my previous reply into the module.
With the insertion point anywhere in the code, press F5 to run it.
Switch back to Excel to view the result.
- Gerry2020Dec 08, 2020Copper Contributor
HansVogelaar OK tomorrow I will try it out when I have to try and sort 400+ inventory tag numbers while keeping their associated serial numbers in the cell below each tag number. Thanks again!