Delete from a table

[JTL9161]

I have a 3 column table 135 rows filled with various and duplicate values. (A1:C135)

I then have another table (1 column) 30 lines (E1:E30)

As values are added to the E1:E30 table I am looking for a formula that will delete ALL the corresponding values from the A1:C135) table.

So if "ABC" is added to cell E1 then all the "ABC" in the table A1:C135 are deleted.

PS. The values in the A1:C135 table are hard coded there. They are not from another source.

Thank you,
James

 

[JTL9161]

Ok so after checking more online I am finding there is no formula that will delete data from a table based on criteria in another table.

But could something with ISNUMBER and MATCH change the data that matches to (" ") I am seeing things like this online but not sure how to apply it to my above description

Any thoughts would be appreciated
James

 

[mumps]

As values are added to the E1:E30 table

If you want to delete the values as they are added, I believe that you would need a macro to do this. If you are open to using a macro, it would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your two tables. 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. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).