Remove rows with custom data in a column

Hi everyone,

I found below code on the forum to find rows in a list of data that contain a certain value in the column D.
I have 2 questions to ask to the forum and hope somebody can help ;-)

1.) Rather than hard-coding, I would like the "user" to have the possibility to insert the values he wants to have removed.
Those values would be in SHEET "CONFIG" from B10:B20. So what is below as "PINCO" and "PALLO", would be a user-defined list of criteria, so the code below would have to change into a loop.

2.) I would like to have some kind of "if is error, then don't do anything" routine in there, because sometimes maybe not ALL cell values are found, so I don't want the macro to stop, just to ignore the error and proceed.

Please Login or Register  to view this content.

Thanks for your help, I am sure this solution will be helpful to others. Also: please don't suggest to manually filter and delete rows, I want to automate that to avoid having to filter and delete rows ;-)


Thanks, TItus

Does this help?

Please Login or Register  to view this content.

Hi John,

thanks for your time. Actually, I'd rather have that instead of a dialog, the script picks up all values that are in B10 to B20 (one in each cell).
Also, the script gives me an error if the data can't be found...

Thanks for your help!
Titus

I attached a sample to illustrate the requirement.

Not sure I'm following you. Especially about the user selections. Maybe you can refine my first code with this code. Or let me know what needs to be changed.

Please Login or Register  to view this content.