Auto Sort Overrides Color Sort

I'm making a database for excel. The goal is to have the data input into it Auto sort by color and then Alphabetically.

I'm using the following VBA to auto sort.

Please Login or Register  to view this content.

And I've set up Macros for the color sorting as follows:

Please Login or Register  to view this content.

The problem is once I input new data, the alphabetical sort overrides the color sort.

Can someone please help me make it so that the color sorting overrides the alphabetical?

Any help is greatly appreciated!

Just add a call to the color sort after the auto sort:

Please Login or Register  to view this content.

Welcome to the Forum, AngXen,

Thank you for adding Code Tags.

Regards.

Hello AngXen,

xladept is usually spot on.

Could you please attach a sample workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

That will enable us to better assist you.

Regards.