classify, sort, and save

[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.

[Leith Ross]

Hello cmccabe,

The two files you said you attached, did not. You should try again.

[cmccabe]

The post here:
http://www.excelforum.com/excel-prog...-and-sort.html

has them in it. I had a problem submitting the thread and it seems the attachments didn't work. Thanks.

If you click no to the opening prompt, then run the classify macro and change the dropdown in A2 to 1 the VBA runs.

[cmccabe]

Are you able to see the files? Thanks.