Button to Automatically Sort Column Values from Largest to Smallest

[bamaguy]

Hi I am looking for a way to have a button to be able to click once I have all of my data entered to sort all values from largest to smallest. I know it has to do with macros and assigning it to a button but could someone assist?

 

[DanteAmor]

Try this

Sub Sort_All()
    ActiveSheet.UsedRange.Sort key1:=Range("A1"), order1:=xlDescending, Header:=xlYes
End Sub

 

[bamaguy]

Try this

Sub Sort_All()
    ActiveSheet.UsedRange.Sort key1:=Range("A1"), order1:=xlDescending, Header:=xlYes
End Sub

Couldnt get this to work.

 

[DanteAmor]

Couldnt get this to work.

It would help a little if you share more information about your sheet. For example: the name of the sheet, in which row your headings are, in which row your data begins.
In which column your data begins, in which column they end.
If you have merged cells, which cells.
If the sheet is protected.
By which column or which columns do you want the order.

If the macro sends an error, what exactly does the macro say.


If you provide that detail of information, it will be easier for you to receive help.