I figured it out. I'm just going to filter columns by "yes" and not have it
pull into a separate sheet. I didn't want to post a sample sheet b/c of
PHI. I'll just to an example next time I have a question with made-up
content.
Thanks for your help!
On Tuesday, October 28, 2014 12:49:30 PM UTC-
Do you want a macro that counts the "yes" values and copies the row?
or woujld it be enough to copy the client ID's to the second page,
then use a =Countif() function to count the "Yes" values and put the result in
the second page.
Then, simply fiter on rows with the count >= 5
Paul
-
can you share sample sheet?
+
*I did not do this for you. God is here working through me for you.*
On Tue, Oct 28, 2014 at 10:19 PM, Jessica wrote:
> I have an excel spreadsheet with client ID#s and varying criteria in each
> column header. If they meet "yes" criteria in 5 of the column hea
I have an excel spreadsheet with client ID#s and varying criteria in each
column header. If they meet "yes" criteria in 5 of the column headers how
do get I get those specific client ID#s to show up in a new sheet? Is there
a formula? I've been doing some research on vlookup. I know some java
p
Check this..
+
*I did not do this for you. God is here working through me for you.*
On Tue, Oct 28, 2014 at 3:11 PM, Nilkanth Raval
wrote:
> Hi Vaibhav bhai,
>
> Your code is working perfectly but in attached file, your code is not
> working correctly.
>
> can you please look into this?
>
>
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Oct 28, 2014 at 1:35 PM, Nilkanth Raval
wrote:
> Hi Vaibhav Bhai,
>
> Working Perfectly. Thanks...
>
> Superb...!! You are amazing
>
> *Thanks,*
> *Nilkanth Raval*
> *+91 900 428 0 428*
> *+91 808 00
Hi Vaibhav bhai,
Your code is working perfectly but in attached file, your code is not
working correctly.
can you please look into this?
Thanks for your valuable help.
*Thanks,*
*Nilkanth Raval*
*+91 900 428 0 428*
*+91 808 000 1620*
*Think Before You Print.Consider ENVIRONMENT.*
*“SAVE TREES,
Hi Vaibhav Bhai,
Working Perfectly. Thanks...
Superb...!! You are amazing
*Thanks,*
*Nilkanth Raval*
*+91 900 428 0 428*
*+91 808 000 1620*
*Think Before You Print.Consider ENVIRONMENT.*
*“SAVE TREES, SAVE EARTH” *
*“All appears to change when we change!”*
On 28 October 2014 11:38, Ashish