Hi
I have a sheet with data only in column A
I want to remove any rows that dont contain the word MAR.
All the lines with MAR in start with:
CN=GR GG COF MAR ****
Would anyone be able to help me with a macro which would do this as i have over a 100 sheets. and maybe an explanation as i am totally new to this?
thanks in advnace