I am completely new to macros so please accept my
apologies if what i am asking is very basic.

I have a spreadsheet full of data (sheet1). I want to
delete all rows in the spreadsheet that do not contain the
word "Total" in column A.

I want to know how to do this if:
i) Any part of the cell contains the word "Total"
ii) The cell only contains the word "Total" (and nothing
else)


Thanks