Need help to look through column to find value/s

[rharri1972]

I have a worksheet("Sheet 1") range is A4:M2000

I want to use VBA to look through Column M to find a value and then once found it will delete that entire row.

Here is the dilemma... there will be several values to find.

Example...this column is Vendors. I am trying to delete several different vendors with one script if possible. We can use Vendors "A" "B" "C" for demsonstration purposes. I don't know if this will be a loop or whatever.
So if this possible your help will be GREATLY appreciated!!

 

[Joe4]

How many vendors do you have?
Could the list of vendors be stored somewhere, i.e. either in a list on a sheet somewhere, or in an VBA array?

 

[rharri1972]

How many vendors do you have?
Could the list of vendors be stored somewhere, i.e. either in a list on a sheet somewhere, or in an VBA array?

Hey Joe...Thanks for your reply. So this report is actually created in our company's management software and I pull it into an xl file and sort from there what i need so the vendor column is already generated and Im trying to keep from having to manually sort through to delete. I have about 8-9 different vendors...currently i have macros for each vendor but am trying to make it one for all. even though only 8-9 vendors but about 2000 lines worth of information.

 

[Joe4]

One way would be to store the list of vendors in an array, and see if the entry for a current row exists in that array.
Andrew's response here shows you one way on how to do that: check if value exists in a vba array

 

[rharri1972]

thank you Joe for your input. Would anyone else have any ideas of whether or not there is a way to do a loop in VBA until all set criteria is met. Looking through one column and deleting entire row for each vendor found that is to be excluded? Vendors "A", "B", "C", and "D"?

 

[Joe4]

thank you Joe for your input. Would anyone else have any ideas of whether or not there is a way to do a loop in VBA until all set criteria is met. Looking through one column and deleting entire row for each vendor found that is to be excluded? Vendors "A", "B", "C", and "D"?

I already told you how to do that. What is the issue with the suggestion?
You have to have some way of telling VBA all the different values (VBA can do a lot of things, but reading minds is not one of them!).
So you need to have a list somewhere, either on a sheet somewhere, or directly in VBA.

Once we have this list, we can loop through the values and the rows and do the deletions.
If you need help formulating this solution, I can help you. But you need to tell me how you would like to proceed, regarding where this list of values we need to search for will exist.