I'd keep a (growing) list of email addresses to delete. Then when you get
the weekly log, Data Filter Advanced Filter. The list range would be
your new log and the criteria would be your running list. The filter will
leave only the rows to delete visibile, so you can just select them all and
delete. As you go through the ones that remain, you'll find new addresses to
add to your 'delete list'.
HTH. --Bruce

"Benson" wrote:

Hi there,

I have a task i have to complete weekly which is really starting to bore me!!

Basically, i receive a report in excel detailing the SMS messages everybody
in the company has sent. I.e. i have a date, senders email, destination,
first name, last name, blah blah blah and the actual message sent. Now im
only interested in the messages sent by my company and not out sister company.

What i have been doing is auto filtering on the Senders email column for the
lines im not interested in and manually delete them, thus leaving me with
just the ones i want to analyse. My question is, does anybody have an idea
how to automaticaaly do this? When the rows i DONT want are identified i
could do with the entire row being deleted, not just the email address cell.

Thanks in advanced, any further info required please let me know!