G
Guest
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
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