Unanswered: Challenge!!Sort all above a moving Total Row.
Im reating a speread sheet where My team can input a list of countries. once done I want them to sort the whole sheet in accordance to country name (column b, ascending). i created a macro to do this as many of them struggle with simple data sort function. My propblem is that my totals row whih sit s below the data keep getting dragged and sorted in with the rest of the data. I've selected a predetemined range of about 230 row to sort, as I figured they can't have more counrties than this to import, however this is where the countries keep getting drgged in. I've worked a macro to always find th e total row no matter how down it is. but hten I'm stuck any ideas? this is as far as I've got..
' Sort Macro
' Macro recorded 03/05/2012 by GBWG6X