If a equals "something" or "something else" do this
 

I have a list of names in column F and starting in row 3. What I would like
to do is write a macro that finds all instances of a certain name and then
deletes that sheet row from my spreadsheet. I was thinking of using an if
statement with an embedded or statement, but i have not come up with
anything. Any help would be great. Example below.

column f

sprint
cingular
virginmo
datawave
tracfone

Find all rows that are Sprint and Tracfone and delete entire row. As an
added feature, if it is possible to instead cut all the rows and paste them
into a new sheet that would be even better.

Thanks so much,

Mike

If a equals "something" or "something else" do this
 

Take a look at the feature Data Filter Autofilter....and the CUSTOM
selection from the drop down arrow.........creative use of the "does not
include" or "begins with" etc will usually give you what you need.......this
filtered result can then be copied and pasted to another sheet.

hth
Vaya con Dios,
Chuck, CABGx3



"MikeD1224" wrote:

I have a list of names in column F and starting in row 3. What I would like
to do is write a macro that finds all instances of a certain name and then
deletes that sheet row from my spreadsheet. I was thinking of using an if
statement with an embedded or statement, but i have not come up with
anything. Any help would be great. Example below.

column f

sprint
cingular
virginmo
datawave
tracfone

Find all rows that are Sprint and Tracfone and delete entire row. As an
added feature, if it is possible to instead cut all the rows and paste them
into a new sheet that would be even better.

Thanks so much,

Mike