delete/filter specific names terminations rows

[rosamoreno]

Hello

I would like to delete a specific rows which contain certain names or termination names.

This is what i have:
photo 1.PNG


and this is what i'd like to have:

photo 2.PNG

as you can see i'd like to delete for exemple all names that have the name 'amide' but also names that have 'amine' termination etc... so i'd like to delete the rows + the UTI and REF for each.

Its basically filtering names and deleting them with their respective informaiton.


Thank you i hope it was clear.

please find attached the excel file

[jindon]

Try

Please Login or Register  to view this content.

[rosamoreno]

it worked thank you!

How can i add more names to delete ? for exemple i tried to add in the line :

If LCase$(Cells(x(i) + 2, 1)) Like "*amide*" , "*amine*", "*formyl*", Then etc but it showed an error...

Thanks

[rosamoreno]

Also, i'd like to delete all rows that contain "nitro", "yne", "ene" etc i've tried to write :

If LCase$(Cells(x(i) + 2, 1)) Like "*amide*" Then
ElseIf LCase$(Cells(x(i) + 2, 1)) Like "*amine*" Then
ElseIf LCase$(Cells(x(i) + 2, 1)) Like "*yne*" Then
etc...

But it didn't work . I'd like to delete more names, not only the ones that contain 'amide'

Thanks again !

[jindon]

Try change to

Please Login or Register  to view this content.

[rosamoreno]

Thank you! it worked for me

[rosamoreno]

Sorry i might have another question. Now that i have this script :

Please Login or Register  to view this content.

Now instead of deleting all the terminations i'd like to keep then only them and deleting the rest with their respective Reference and UTI

Thanks a lot