Filters

[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

 

[Debra Dalgleish]

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

 

[Debra Dalgleish]

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.