classify and sort

[cmccabe]

I am trying to create a multi-step VBA and am close, but need some expert help on the last steps. In the attached spreadsheet three 3 happen:
1. When it is opened it asks for new data
2. When the classify macro is run the sheet is reformatted
3. When the dropdown in A2 is changed it triggers another macro (calculations)

That all seems to work, what I am having trouble with is putting values in the classification column, highlighting them appropriately, sorting them based on column, and saving that new spreadsheet in a directory. I know that is a lot, but it would help out and save a lot of time for users. Below is a code that works up until the Clinvar step in calculations (that is where the issues above happen). I thought I did it right, but it doesn’t seem to be working. Thanks .

I have attached two spreadsheets
TestBook has the highlighting and classification columns correct and just needs to be sorted
1. Pathogenic on top, followed by likely pathogenic, then Variant of Unknown Significance, then ????, then likely benign, and benign
Example has the macros in it.

I hope this makes sense and can be done.

[cmccabe]

trying to delete as this is a duplicate post and the other post is the correct one. Thank you and sorry.