Apr 11 2022 02:37 PM
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.
Apr 11 2022 02:48 PM
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.
Apr 11 2022 03:08 PM