Delete Row based on cell value

[esmecat]

Hi

I have read several threads on this but just can't seem to get this to work for my criteria.

I have a range of data that varies week to week by number of rows.

I would like to delete all rows that contain a certain word e.g. "Carrot" in column B of the data

I would then like to also delete all rows that contain the word "potato", also in column B of the data

Any help would be appreciated.

 

[hiker95]

esmecat,

Can you post a screen shot of what your data looks like?

Section B at this link has instructions on how to post a screen shot: https://www.mrexcel.com/forum/board-...forum-use.html

Alternately, you could upload a copy of your file to a free site such as www.box.com. or www.dropbox.com.

Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.

Include a detailed explanation of what you would like to do referring to specific cells, rows, columns and worksheets.

If the workbook contains confidential information, you could replace it with generic data.