Filtering an Excel file

[GraeagleBill]

I don't normally cross-post, but with one foot in Access and the other in Excel it sometimes becomes necessary to tap into both bodies of knowledge.......................

In the following Sub, an Excel sheet is filtered to the current value of the current report number, "RptNum". Does anyone know how to modify the filtering statement to filter column 1 to "RptNum" OR column 2 equal to the string "RU"?

Please Login or Register  to view this content.

[dominicb]

GraeagleBill

If you must cross post, then please edit your question and supply links showing where it has been cross posted so our users can see if your question has been answered.

DominicB

[GraeagleBill]

That never occurred to me for two reasons. First I think in the last 20 years I've maybe cross-posted 3 times and second that I take the responsibility to post any solution on both forums when a conclusion is reached. However, your point is well taken and one can view the same post at http://www.accessforums.net/showthread.php?t=71485 if interest warrants.

[AliGW]

Thank you for providing the link.

The cross-posting rule, and the other simple rules we ask you to follow, are outlined here: https://www.excelforum.com/forum-rul...rum-rules.html

Please take a moment or two to read them through so that you know and understand what our expectations are.

[mjr veverka]

There is no direct "OR" for 'Autofilter' method for two fields together, but if we take into account the importance of logical operators, "OR" in this case:

p | q | p v q
========
0 | 0 | 0 => all False
1 | 0 | 1 => "RptNum" is True
0 | 1 | 1 => "RU" is True
1 | 1 | 1 => "RptNum" and "RU" are True

where "1" is True

it can be done indirectly.

Try something like that and see if it works:

Please Login or Register  to view this content.

If this is not true, then colleagues on the forum will improve me ...