Delete a row with a certain phrase?
 

Is there any way to have excel automatically delete any rows that have
given phrase in them

--
dzi
-----------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...fo&userid=1042
View this thread: http://www.excelforum.com/showthread.php?threadid=56128

Delete a row with a certain phrase?
 

This link might get you started


http://www.ozgrid.com/VBA/row-delete-criteria.htm

VBA Noo

--
VBA Noo
-----------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...fo&userid=3383
View this thread: http://www.excelforum.com/showthread.php?threadid=56128

Delete a row with a certain phrase?
 

Alright. I have NO experience with VB or Macros in excel, so I have no
idea how to set this up..any help?


--
dziw
------------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422
View this thread: http://www.excelforum.com/showthread...hreadid=561286

Delete a row with a certain phrase?
 

Alright. Well all those scripts seem to have syntax errors.
I used ones from http://www.rondebruin.nl/delete.htm
I have a question. Is there any way to make it so that the value
doesn't have to be the whole cell?

i.e.
Cell=Note: blah blah balh
Cell2=Note: blah2 blah2 blah2

Is there any way to make it search for "Note:" and remove it? Becasue
from what I've tried the value has to be the ENTIRE cell, not just part


--
dziw
------------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422
View this thread: http://www.excelforum.com/showthread...hreadid=561286