Autosorting of two rows

Hi guys, I need help to make a code that sorts correlations from highest to lowest.

The first row is Brands and the other one is correlations. Since it's correlations, there will be negative values.
Furthermore, does the macro work with normal references and or v-lookups?

Excel.JPG

I figure it is quite simple, but as I am new to VBA (You might heard that on before) it is not that easy.

Thank you in advance.

Get rid of that empty row 3
Then in row 2 add Filter (Data -> Filter) and sort by second column.

Or with VBA (without header) it would look something like:

Please Login or Register  to view this content.

Didn't test it so let me know if not working

Looks fine to me.

Please Login or Register  to view this content.

I don't understand

When I run the code, it does not sort from highest to lowest correlation. Furthermore, Brand 1, Brand 2.... Does not follow its values.
Furthermore, it seems like the sorting gets messed up because the array is made from "v-lookups" and references. If you sort traditionally, you only use values - that is why I asked if I should only use "values" and not v-lookups and references.

Thank you.