Ok, First i have a Word report i copy over to the original macro1 and macro 2 and it cleans it up for me, next (where i could use a updated macro) then i copy to a new sheet and sort on Column A and remove all the data that (in this case, the line starting PM and below--- all data for the rest...