I am trying to create a macro in Excel.
I am trying to do a search on say summary. I have placed an * as the first character of the summary to put those at the top. After those are found, everything after the * needs to go in sort order by another field. For now, I have had to do a sort on summary first and then highlight everything below that and then do my second sort. Is there any way to change that macro using VB so that it can be programmed to "find" that last row of the first sort and then sort everything down below it using the second criteria?