$$Excel-Macros$$ Re: How to pull ID#s that meet "yes" to different criteria columns into seperate sheet

2014-10-28 Thread Jessica
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-

Re: $$Excel-Macros$$ How to pull ID#s that meet "yes" to different criteria columns into seperate sheet

2014-10-28 Thread Paul Schreiner
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 -

Re: $$Excel-Macros$$ How to pull ID#s that meet "yes" to different criteria columns into seperate sheet

2014-10-28 Thread Vaibhav Joshi
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

$$Excel-Macros$$ How to pull ID#s that meet "yes" to different criteria columns into seperate sheet

2014-10-28 Thread Jessica
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

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-28 Thread Vaibhav Joshi
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? > >

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-28 Thread Vaibhav Joshi
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

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-28 Thread Nilkanth Raval
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,

Re: $$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-28 Thread Nilkanth Raval
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