creating form/filter in Excel
 

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: , , "

Thanks again.

creating form/filter in Excel
 

Just use Autofilter (DataFilterAutofilter) on all of the columns.

--
HTH

Bob

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

wrote in message
oups.com...
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: , , "

Thanks again.