Specific sorting macro for 2 columns

**eddthebed** · 04-21-2016, 12:08 PM

Hi, I need help on sorting 2 columns and as there are many thousand rows doing it manually doesn't cut it. As it is kinda difficult to describe I will just provide an example.
Suppose we have columns A and B with values as provided. I need to sort these two columns so that it would look like it can be seen from 9th to 14th row. Any help will be appreciated!

excel_example.PNG

**xladept** · 04-21-2016, 12:13 PM

If there is no adjacent data then:

Please Login or Register  to view this content.

And, welcome to the Forum!

If you haven't used macros before you'll need to go to:
File- options - trust center -trust center settings - macro settings ,
the second option down (disable all macros with notification)

Then - Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Select "Module" from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name
*Be sure to save the book with the code as Macro-Enabled