$$Excel-Macros$$ Need VBA code that will compute number of "Yes" against each question in the given Questionaire

2014-08-01 Thread Sandeep Kumar Baranwal
Hi I need your help in getting a VBA code that will compute the number of "Yes" chosen by 1000 respondents for each question in the given Questionaire ? Kindly note that this Questionaire would be circulated to 1000 targeted persons. There are , say for example, 10 questions in the given question

Re: $$Excel-Macros$$ Excel Macros Help

2014-08-01 Thread Vaibhav Joshi
PFA, we can modify to suits you once you revert on my query. Cheers!! On Thu, Jul 31, 2014 at 12:05 PM, Vaibhav Joshi wrote: > Thanks for file.. > > Query! > > say Group1 status for order 1 is ABC, so on next day whether there will be > any change in status or not? > > If it changes then do yo

Re: $$Excel-Macros$$ Data separation by formula

2014-08-01 Thread Vaibhav Joshi
Cheers!! On Fri, Aug 1, 2014 at 3:41 PM, Nur Hossain wrote: > Joshi da,it works perfectly , thanks for your help > . > > > On Fri, Aug 1, 2014 at 1:45 PM, Vaibhav Joshi wrote: > >> PFA >> >> Cheers!! >> >> >> On Thu, Jul 31, 2014 at 11:52 PM, Nur Hossain wrote: >> >>> Dear all, Data separati

Re: $$Excel-Macros$$ Data separation by formula

2014-08-01 Thread Nur Hossain
Joshi da,it works perfectly , thanks for your help . On Fri, Aug 1, 2014 at 1:45 PM, Vaibhav Joshi wrote: > PFA > > Cheers!! > > > On Thu, Jul 31, 2014 at 11:52 PM, Nur Hossain wrote: > >> Dear all, Data separation by formula >> CELLA having data like below >> >> 3RB2 AIS 130719 13

Re: $$Excel-Macros$$ Is it possible to visible an Add ins own worksheets when it installed with a new workbook.

2014-08-01 Thread Vaibhav Joshi
Yes it is possible.. Check this..http://www.vbaexpress.com/kb/getarticle.php?kb_id=427 Cheers!! On Fri, Aug 1, 2014 at 2:39 PM, Divaker Pandey wrote: > Hi Experts, > > > I created an add-in in excel 2010, having multiple worksheets with custom > menu. I need when this add ins installed with a

$$Excel-Macros$$ Is it possible to visible an Add ins own worksheets when it installed with a new workbook.

2014-08-01 Thread Divaker Pandey
Hi Experts, I created an add-in in excel 2010, having multiple worksheets with custom menu. I need when this add ins installed with another workbook, add-ins tab must be visible, is it possible? Regards, Divaker -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIM

Re: $$Excel-Macros$$ password protect and hide worksheet in excel.

2014-08-01 Thread Abhilash Barapatre
thanks a lot.. On Fri, Aug 1, 2014 at 1:23 PM, Vaibhav Joshi wrote: > Check this.. > > http://www.vbaexpress.com/kb/getarticle.php?kb_id=380 > > Cheers!! > > > On Thu, Jul 31, 2014 at 11:36 PM, ab12tatre wrote: > >> Hello All, >> >> I want to hide a worksheet with Password protection in such a

Re: $$Excel-Macros$$ password protect and hide worksheet in excel.

2014-08-01 Thread Vaibhav Joshi
Check this.. http://www.vbaexpress.com/kb/getarticle.php?kb_id=380 Cheers!! On Thu, Jul 31, 2014 at 11:36 PM, ab12tatre wrote: > Hello All, > > I want to hide a worksheet with Password protection in such a way that, > unless we enter the password no one will come to know that there is an > hi

Re: $$Excel-Macros$$ Re: Need solution for my excel sheet

2014-08-01 Thread Vaibhav Joshi
cheers!! On Fri, Aug 1, 2014 at 1:15 PM, Abhilash Barapatre wrote: > yes it helped thanks a lot. sorry, i couldnt reply. > Now I got a new problem in same sheet. > > I want to hide a worksheet with Password protection in such a way that, > unless we enter the password no one will come to know t

Re: $$Excel-Macros$$ Re: Need solution for my excel sheet

2014-08-01 Thread Abhilash Barapatre
yes it helped thanks a lot. sorry, i couldnt reply. Now I got a new problem in same sheet. I want to hide a worksheet with Password protection in such a way that, unless we enter the password no one will come to know that there is an hidden sheet. Only after entering the password i should be able

Re: $$Excel-Macros$$ Data separation by formula

2014-08-01 Thread Vaibhav Joshi
PFA Cheers!! On Thu, Jul 31, 2014 at 11:52 PM, Nur Hossain wrote: > Dear all, Data separation by formula > CELLA having data like below > > 3RB2 AIS 130719 13414056RB2RDI > 140619 124341872RB2 LOFYT 130619 >