G Guest Oct 26, 2007 #1 How do I delete several rows that don't have the word total. I want to keep the rows with word total in column A. Thanks
How do I delete several rows that don't have the word total. I want to keep the rows with word total in column A. Thanks
D Don Guillett Oct 26, 2007 #3 Easiest would be to sort and delete or data>filter>autofilter>delete or a looping macro
D David Biddulph Oct 26, 2007 #4 Try autofilter? Custom/ does not equal/ Total, then Delete row, should leave the ones with Total. Save the existing file first though, just to be on the safe side.
Try autofilter? Custom/ does not equal/ Total, then Delete row, should leave the ones with Total. Save the existing file first though, just to be on the safe side.
