Deleting Multiple Rows based on Cell Content

[pdreyest]

Hi,

I have been banging my head for a few hours. I am your average Excel user and I need to delete multiple rows in one shot by using content in a cell as an identifier. See example attached. I have used safe data with similar fields to play with. The real file has about 7K rows and I need to be able to delete 5K. For example, If I need to delete Pollo Loco, Gaucho Conciente and Res all in one shot, is there a formula or script that can be ran? My original list of clients has over 55.

I really need all the help I can get!

[mike7952]

Give this a try.

Please Login or Register  to view this content.

Edit: Create your list of clients to delete on another sheet Column A starting in row 2

[pdreyest]

Thanks Mike!

I tried running but I did not see any changes reflect on the work sheet. Am I doing something wrong? See below:

Please Login or Register  to view this content.

[mike7952]

What Column is your clients in on the raw sheet. In your example It was Column B.

Please Login or Register  to view this content.

[pdreyest]

They are on column B. I have them listed as Bus Part though in the actual document.

[Cutter]

@ pdreyest

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

[pdreyest]

@ cutter

Thanks for the feedback. Will keep in mind.

[mike7952]

They are on column B

Then What column needs to be Column B not A

Please Login or Register  to view this content.

I have them listed as Bus Part though in the actual document.

Whats Bus Part??

[pdreyest]

@Mike7592

Worked like a charm. Thanks so much for your help!!!

Bus Part is the nomenclature of each client in our systems.