$$Excel-Macros$$ Is there a way to exclude PERSONAL.xls workbook from list of active workbooks in macro?

2013-04-06 Thread LJGIT
I need to switch between two workbooks several times to copy/paste data. One workbook is static (SHS form.xls) and can be explicitly named in macro but the other is dynamic so need to use variable. Macro is stored in PERSONAL.xls and is launched from the dynamic workbook. Macro opens SHS f

Re: $$Excel-Macros$$

2013-04-06 Thread prafull jadhav
Please share a example file with criteria On Sat, Apr 6, 2013 at 3:45 PM, Shrinivas Shevde wrote: > > Dear All > Can Anyone answer this > > Regards > Shrinivas > > > On Mon, Apr 1, 2013 at 1:48 PM, Shrinivas Shevde > wrote: > >> Dear Rajan >> Thanks for reply >> >> Column E,F -: May be blank if

Re: $$Excel-Macros$$

2013-04-06 Thread Shrinivas Shevde
Dear All Can Anyone answer this Regards Shrinivas On Mon, Apr 1, 2013 at 1:48 PM, Shrinivas Shevde wrote: > Dear Rajan > Thanks for reply > > Column E,F -: May be blank if there is value Character should not be > greater than 60 > > Column G -: Should not be blank and Character should not b

RE: $$Excel-Macros$$ Countif Formula Declaretion

2013-04-06 Thread Priti_verma
Please see the attachment to understand the use of comparision operator in countif formula. Regards, Priti verma From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of prafull jadhav Sent: 06 April 2013 2:21 To: excel-macros@googlegroups.com Subject: Re: $$Exc

Re: $$Excel-Macros$$ Countif Formula Logic

2013-04-06 Thread prafull jadhav
Dear Amar, These both formula is same ..when you use the countif function then use =COUNTIF($F$3:$F$74,B3) and if there is multiple condition while counting then use countifsfunction then you have to write formula like =COUNTIF($F$3:$F$74,"="&B3) find the attachment I have mentioned the examples

RE: $$Excel-Macros$$ Countif Formula Logic

2013-04-06 Thread Priti_verma
See = is a comparison operater in countif which is default for this function .so doesn't matter if we are using = in our function or not. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Abhishek Jain Sent: 06 April 2013 1:51 To: excel-macros@googlegrou

RE: $$Excel-Macros$$ Countif Formula Logic

2013-04-06 Thread Priti_verma
Hi Amar , There is no difference between these formulas.if u have any doubt please mention your query with example. Regards, Priti Verma From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: 06 April 2013 1:47 To: excel-macros@googlegroups.

Re: $$Excel-Macros$$ Countif Formula Logic

2013-04-06 Thread Abhishek Jain
When you use "=", "<", ">" with countif, you need to use "&". I think so...not sure. On Sat, Apr 6, 2013 at 1:46 PM, amar takale wrote: > Dear Experts > > what is Different between two formulas bcos from this formula I got same > answer.So what is logic of "="& > > =COUNTIF($F$3:$F$74,"="&B3) >

$$Excel-Macros$$ Countif Formula Logic

2013-04-06 Thread amar takale
Dear Experts what is Different between two formulas bcos from this formula I got same answer.So what is logic of "="& =COUNTIF($F$3:$F$74,"="&B3) =COUNTIF($F$3:$F$74,B3) Regards Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join offic

Re: $$Excel-Macros$$POP UP

2013-04-06 Thread xlstime
Hi Manjunath, Please find below the code for auto run after 15 min with msgbox, for testing propose change timevalue and try.. placed inside thisworkbook Private Sub Workbook_Open() Call TimeUp End Sub and placed inside module Sub UpdateTime() Application.OnTime Now + TimeValue("00:15:00"), "T