Auto sort excel table in VB

I'm trying to auto sort a table in excel. I want to have the table in "Summary" sheet automatically sort when a cell is changed in column A. I also want the numbers in the sort to be sorted last so that the text is first in the list.

I've attached the file I'm working on. I copied a macro to auto sort in VB but it does not work right. The cells in column A refers to another cell. When I change the value in the other cells the table will not sort. I also get an error message when i open the file now.

Can anyone help?

I don't know how you change the value in Protected sheet though.

To Summary sheet module

Please Login or Register  to view this content.

This works perfect! Thank you.

The cell values in column A come from other sheets. This is why it's locked and protected and how the values are changed.

I spoke too soon. The problem is when I change a Sheet name from a number to a Text I get the error "#value!". It looks to me the module it refers to cell "C3" as a number. So this adds a "+0" to my formula in the C3 cell.

Any suggestions?

Try replace following part in "mySort" sub procedure

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

That seems to work.

Thank you.