Alright, so I have some code that looks through multiple columns for the value "no" and if it is true, then it pulls that row. I need this to happen if there is a "no" in ANY of the cells listed.
For some reason the macro is only pulling 6 of 13 rows that have the value "no".
I'm wondering what the problem could be. Do I need some sort of and/or function?
Thanks!
Please Login or Register to view this content.
acer1234
For things more complex than a cell or two, I prefer to use a formula in an empty column to "check" all the cells and give me a TRUE result if this row "qualifies". For your columns, I'd suggest the first formula to check row 2 would be:
=SUM(COUNTIF(DX2:ED2,"no"),COUNTIF(EH2:EQ2,"no"),COUNTIF(GC2:GG2,"no"))>0
Here's a macro that will insert that formula into the last column on the sheet and then filter for "TRUE", it then grabs all the TRUE rows together, all at once, and copies them onto the Time Critical sheet.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
That worked Great *****. But how do I get it not to put the true in the last row, my cell usage only goes to HU.
THANK YOU
Oops! We were supposed to remove those formulas when we were done. Sorry.
Please Login or Register to view this content.
If that takes care of your need, please select Thread Tools from the menu above and mark the thread as solved. Thanks.
Last edited by JBeaucaire; 09-18-2012 at 12:54 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks