Sorting - caution: newbie question

New Contributor

I am creating a vba macro in Excel 2013.   I have a spreadsheet that has 2 columns.

Column A is an alpha numeric part number.  Column B is qty on hand.

I want to sort column A, a-z and want to keep the column B qty on hand with the part number.



   Column A   Column B

      Mark1         25

      Jig47         3

      Zerk          2.5

      Auger        68



       Auger      68

       Jig47        3

       Mark1      25

       Zerk         2.5


Googled but didn't find anything clear.


2 Replies


Click  in one of the part numbers in column A, for example in Mark1.

On the Home tab of the ribbon, in the Editing group, click Sort & Filter > Sort A to Z.

If you’re a newbie: don’t start with VBA.
Use one sheet with date, use the second sheet for formula’s that refer to the first page. Consider formulas like Unique, Sort and Filter. Or all free in one formula.