macro help

[bflan0524]

ive never built a macro so was looking for some help or a resource somebody could point me to.
basically i have a dynamic page that changes based on the person picked on a control page. on this dynamic page there are many columns but two titled $ Change and % Change. i need a filter for this page where you can press the macro and it will sort the page for $ Change from highest to lowest, it could also do the same if you select the % Change column

you can't filter/sort the page currently because of all the formulas on it, it just never works and sorts properly

ty

 

[bflan0524]

.
You could replace the real names / acct #'s or whatever with false pseudo terms.

so good news and bad news haha. i fooled around to try and build my own, which is below. but how do you do it so all the columns associated with the record sort too. for example Column A row 1 is company called sisters of mercy, in column AN the value associated with it is (10). when i do the sort the column AN9 changes properly in ascending order, but now Sisters of Mercy shows say 700 in column AN as opposed to the (10). does that make sense

Sub SortDataWithHeader()
Range("AN9", Range("AN9").End(xlDown)).Sort Key1:=Range("AN9"), Order1:=xlDescending
End Sub

 

[Logit]

.
You really need to post a copy of your workbook. It is very difficult if not impossible to troubleshoot
without it.

Sorry.