PC Review


Reply
Thread Tools Rate Thread

creating form/filter in Excel

 
 
fjalexander@gmail.com
Guest
Posts: n/a
 
      14th Aug 2007
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 Removed), (E-Mail Removed), (E-Mail Removed)"

Thanks again.

 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      14th Aug 2007
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)

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 Removed), (E-Mail Removed), (E-Mail Removed)"
>
> Thanks again.
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Creating a query filter form for users Beetle Microsoft Access Forms 0 20th Jan 2009 06:09 PM
Creating a filter form solitudebytheshore Microsoft Access Forms 1 21st Sep 2008 12:01 PM
creating a filter with a form timglass via AccessMonster.com Microsoft Access Form Coding 15 27th Sep 2006 09:11 PM
Form creating a new record when filter fails lantel@gmail.com Microsoft Access Forms 3 4th Apr 2005 10:14 AM
Creating / enabling a filter button on a form. =?Utf-8?B?Sm9obg==?= Microsoft Access Form Coding 1 24th Feb 2005 12:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:48 PM.