Sorting - caution: newbie question

Copper 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.

ie

before

   Column A   Column B

      Mark1         25

      Jig47         3

      Zerk          2.5

      Auger        68

 

After

       Auger      68

       Jig47        3

       Mark1      25

       Zerk         2.5

 

Googled but didn't find anything clear.

Thanks.      

2 Replies

@DarrylH42022 

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.