Filters

  • Thread starter Thread starter Jessica
  • Start date Start date
J

Jessica

Could you pleae help me trouble shoot a filter problem in
Excel 97 SR-2. I have several sheets of information. I
have created an appointment/scheduling book out of my
worksheets. After I enter the personal information and
the appointment date for many clients. When I attempt to
do a filter, i am not getting the accurate number of
records.

I have noticed that when I do a >filter >Show All, I can
see my Validation (List)over to the side (where I have
entered the Validation list)...But when I filter the date
needed, I do not see any lists (Validation) information,
out to the side. Am I supposed to see the list on each
sheet or even the validated line which was selected?


Please help!

Jessica
 
It's not clear to me what you're trying to filter. Perhaps you could
provide a few more details. For example:
--Are you using AutoFilter or Advanced Filter?
--How do the 'sheets of information' relate to the filter?
--Where do you enter the appointment dates and personal info?
--What is the Validation List used for?

There are some instructions here for AutoFilter:
http://www.contextures.com/xlautofilter01.html
and for Advanced Filter:
http://www.contextures.com/xladvfilter01.html
 
Are your dates being entered in a valid format, so they're recognized as
dates? For example, 1/1/2003 is a valid format, but June 13th isn't.
 
Back
Top