creating form/filter in Excel

[fjalexander]

Thank you in advance for your help.

A spam filter reports all mail blocked in a .csv file that is imported
into Excel. Each record contains date, time, from, ip, subject, etc.
Is there a way to build a front end form in Excel that would allow a
user to enter her/his e-mail address that would then would list all
matching records (but only select fields from those records)?

Caveat: the "to:" field in each record (the field to be searched based
on user input of e-mail address) may contain more than one e-mail
address seperated by a comma and space.

Example: "(e-mail address removed), (e-mail address removed), (e-mail address removed)"

Thanks again.

 

[Bob Phillips]

Just use Autofilter (Data>Filter>Autofilter) on all of the columns.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)