How do I create a dynamic variable to sort my data. I'm attempting to creat
buttons to sort by last name, total_score, ID, location.

Thought if there was a way to set a variable (my sort range), I could then
sort it on any of those criteria. Hope that makes sense.

its this first part after the word Range ( ??????) instead of "A2:O120" I
want it to find the last row and create that Range as a variable

Range("A2:O120").Sort Key1:=Range("E2"), Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom, _
DataOption1:=xlSortTextAsNumbers

Sorry, new to this stuff..

Thanks in advance

Jeff