Excel How to Auto-Alphabetize a Specific Range in Excel?

[J_Dodge]

I'm trying to find a macro which will automatically sort alphabetically by a specific range.

After I filter column A (for a specific reoccurring value) I want the remaining values in columns AC-AH to sort alphabetically by column AD automatically.

I've looked all over the internet but cant seem to find one applicable. I know how to run them but no idea how to create on myself!

Any suggestions?

 

[Becky]

Welcome to the forum!

If you're new to macros then the easiest way to create one is to record it manually. Go to the View tab and click on the downward pointing arrow below the Macro button, then select Record macro. You will have to give it a name, and you can assign a shortcut to it. Once you have entered the information click on OK and go through the actions you want to record. When you are finished click on the downward pointing arrow again and select Stop recording.

If I've missed the point of what you're asking let me know!