I have the following macro currently in my sheet,
Range("A11:XFC5000").Sort Key1:=Range("F11"), Order1:=xlAscending, Header:=xlYes, OrderCustom:=1, MatchCase:= _
False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
how do I edit this so it also then sorts by first name ascending the range would be E11. At the moment it is only sorting surnames but I woiuld like it to then sort the first names accordingly.