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!