[mso] Excel Advanced Filter Dillema

Hi All,=20

I've got a bit of an advanced filter dilemma, and knowing the great
minds on this forum, I knew exactly where to start for the solution.

I am trying to create an advanced filter using formulas in the criteria
section, which picks up values keyed in on another tab from the same
spreadsheet. I have about 10 criteria going across the page, but the
user can only apply one at a time, meaning that only one cell at a time
in the criteria section will have a value, and all other criteria cells
will have no value in them (worked using an if formula"

Excel doesn't seem to like the formulae bit in the other criteria cells
and seems to be treating the formula itself as a criteria, because it is
not throwing back any values.

However, if I perform the same advanced filter by manual keying in the
criteria values, this seems to work just fine.

In the cells where there is a formula, but there is no value returned
(in criteria section), how do I tell excel to treat the cell as being
blank, so that it does not confuse the advanced filter?

Or does anybody know of any other way to get round this dilemma?

Many thanks

Herbert
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: