Hi Frndz,
It would be much appreciated if someone could help me create a spreadsheet
whereby if I type "Desk" in cell C1, "Fire Damper" in cell C2, "Fire
Sprinkler" in cell C3, and "Garden Sprinkler" in cell C4, then type "Fire
Sprinkler" in cell A1, it will search for the words "Fire" and "Sprink
Hello Team,
Can someone assist me with the excel formula based on the criteria from B44
to B50, PFA the excel file.
Thanks in advance.
--
Indrajit
talk2indra...@gmail.com
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of t
Hi Experts,
Is there any way that chart level colors will be changed automatically, say
when it's negative value it should be in Red color and vice versa as Green
color.
[image: Inline image 1]
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
a
Hi All,
Can anyone would like to provide me an Excel data mapping tutorial with
various formulas and functions.
Thanks in advance.
--
Indrajit
talk2indra...@gmail.com
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the i
TATE_COMPLETE
>
> DoEvents
>
> Loop
>
>
>
> IEApp.Navigate "test.com"
>
>
>
> Do While IEApp.Busy Or IEApp.ReadyState <> READYSTATE_COMPLETE
>
> DoEvents
>
> Loop
>
>
>
>
>
>
>
>
>
> &#
Hi All,
I just need a small favor from your end, please have a look at the code I
have explained everything over there. My requirement is as follows;
Its just a popup with blank forms, the forms need to be filled with the
data from row"x" and columns E-L
I already managed to "getelementbyid" fro
Thanks a lot Jayavelu. :)
*Thanks! Indrajit*
On Thu, Mar 13, 2014 at 1:01 PM, JAYAVELU SUN wrote:
> This is solution for State =MID((RIGHT(A17,8)),1,3)
>
> this is solution of pin code =right(right(A17,4)
>
>
> On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai wrot
Thanks Shahzad.
On Mon, Mar 17, 2014 at 12:04 PM, Aamir Shahzad wrote:
> Hi Indrajit,
>
> try this
>
>
> =IF(ISERR(FIND("ACT",A4,FIND("ACT",A4)+1)),LEFT(A4,FIND("ACT",A4)-1),LEFT(A4,FIND("ACT",A4,FIND("ACT",A4)+1
Thanks Ashish.
On Sun, Mar 16, 2014 at 8:56 PM, ashish koul wrote:
> then try left and find function combined
>
>
> On Sun, Mar 16, 2014 at 1:02 AM, Indrajit $nai wrote:
>
>> Yes Ashish...
>>
>>
>> On Sat, Mar 15, 2014 at 3:39 PM, ashish
Yes Ashish...
On Sat, Mar 15, 2014 at 3:39 PM, ashish koul wrote:
> is ACT common in all
>
>
> On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai wrote:
>
>> Hi Experts,
>>
>> Is there any way out to split up an address as per the attached file
>> format!
Hi Experts,
Is there any way out to split up an address as per the attached file format!
If so then please provide me the formula or vba code (anything).
Thanks in advance.
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely f
together
> something similar a couple of months back
>
> Regards,
> Priyanka S
>
>
>
>
> On Sat, Dec 14, 2013 at 10:32 PM, Indrajit $nai
> wrote:
>
>> Hi Experts,
>>
>> I have a report (excel file) that shows the number of calls by hour over
>>
Hi Experts,
I have a report (excel file) that shows the number of calls by hour over
the last 6 weeks. I would like this rolled up and broken down to show the
percentage of weekly call volume broken down by hour per day. Essentially,
take an average of every hour for the 6 weeks and then put that
Thanks to all of you.
On Sun, Dec 8, 2013 at 4:01 AM, Amit Desai (MERU)
wrote:
> I have converted the file in .xlsb version.
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 08 December 201
Hi Experts,
PFA both the files.
1. Purchase order template
2. Database
*Requirement:*
- I want to create a Purchase Order file database, suppose if I enter
something in the purchase order file and save the same (you can create a
button) then it will save in the Database file.
- In the Database
legroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* Friday, November 08, 2013 2:39 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Need PDF to Excel Converter.
>
>
>
> Ravinder, need a small edit on this, have to add Company name, Preferred
> Ph
u, Nov 7, 2013 at 4:00 AM, Ravinder wrote:
> PFA.. I have copied PDF data in second sheet and then click on button.
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* Thursday, November 07, 2013 1:01
Hello Experts,
Kindly find attached the file, and can anyone please explain me why the
results are comming different by using the same kind of formula in the
column no. E2 and E4?
Thanks in advance.
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confident
s@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* Friday, October 04, 2013 7:13 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help required in formula.
>
> ** **
>
> Hi Ravinder,
>
> ** **
>
> Actually it wa
d
> drag
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* Thursday, October 03, 2013 1:29 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help required in formu
t; ** **
>
> Next
>
> ** **
>
> End Function
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* Thursday, October 03, 2013 5:56 AM
> *To:* excel-macros@googlegroups.com
Hi Experts,
PFA, kindly let me know is there any formula to sum-up the col B nos into
col D.
As of now I am doing it manually, but it's very long term process!
Kindly let me know is there any way out to do it through any formula.
Thanks in advance.
--
Indrajit
Disclaimer:
This electronic mes
tended recipient you are hereby
notified that any disclosure, copying, distribution or taking any action in
reliance on the contents of this information is strictly prohibited and may
be unlawful.
On Wed, Sep 25, 2013 at 1:07 PM, Indrajit $nai wrote:
> Thanks Ravinder for your kind help. I h
ay
be unlawful.
On Tue, Sep 24, 2013 at 2:21 PM, Ravinder wrote:
> Try this.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* Tuesday, September 24, 2013 1:40 PM
>
> *To:* excel-macros@
sed. If you are not the intended recipient you are hereby
notified that any disclosure, copying, distribution or taking any action in
reliance on the contents of this information is strictly prohibited and may
be unlawful.
On Thu, Sep 19, 2013 at 1:54 PM, Indrajit $nai wrote:
> Thanks a l
ups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* Thursday, September 19, 2013 12:49 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Need experts help ***URGENT***
>
> ** **
>
> Both of you are simply AWESOME
on or taking any action in
reliance on the contents of this information is strictly prohibited and may
be unlawful.
On Thu, Sep 19, 2013 at 4:33 AM, Indrajit $nai wrote:
> Hi Experts,
>
> I am facing some problem with this macro file, actually the macro is
> running pretty well, but nee
Thanks a lot to both of you.
You guys are simply awesome :)
On Mon, Aug 19, 2013 at 12:31 PM, ravinder negi wrote:
> add below "Microsoft Scripting Runtime" library from tool-->reference
>
>
> ------
> *From:* Indraji
ered in sheet 1 & will apply restrictions too with error message.
>
> Cheers!!
>
>
>
>
>
>
> On Mon, Jul 1, 2013 at 12:21 AM, Indrajit $nai wrote:
>
>> Hi All,
>>
>> PFA.
>>
>> I want to create the validation through Macro, can the E
Hi All,
PFA.
I want to create the validation through Macro, can the EXPERTS help me on
this?
Requirement is on the 1st sheet and the Table data is on the 2nd sheet.
Thanks in advance.
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and inten
Hi All,
How many Control chart / Defect chart are there in a Business to identify
Business / Process defect? I know some of them, like Pareto analysis,
Fishbone diagram, but are there any other chart is available to measure the
defect? If so, then please provide me some samples.
Thanks in advance
a Limited (naukri.com)
>>>> Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
>>>> naukrikuld...@gmail.com || www.naukri.com
>>>> *Please* *Consider the environment. Please don't print this e-mail
>>>> unless you really need to.*
>>&
Hi all,
please provide me some basic training materials of Excel .
thanks in advance.
--
Indrajit
talk2indra...@gmail.com
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they
are addressed
; In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
> --
> *From:* Indrajit $nai
> *To:* excel-macros@googlegroups.com
> *Sent:* Tue, February 19, 2013 5:12:33 PM
&g
t; At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *---------
>
>
> --
> *From:* Indrajit $nai
> *To:* excel-macros@googlegroups.com
> *Sent:* Tue, February 1
Sorry attached wrong file, in my previous mail...
On Tue, Feb 19, 2013 at 8:09 PM, Indrajit $nai wrote:
> Hi Experts,
>
> Need a small help from your end. I've created a login and logout time
> tracker, which is working perfectly, but I want to show running login hrs
>
Hi All,
I wanna import / export webpage content through macro, if it is possible
through VBA coding then plz provide me the VBA code.
Kindly chk the attached file for your reference.
*My requirement:* Actually I'm able to import the webpage content through
the attached file, but I am not not abl
Hi All,
Is it possible to convert a Bitmap image (BMP) into a Excel file through
some Macro?
If it is possible then please send me the code.
Thanks in advance.
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of
*@ Krishna, Sir right now it's working fine.thanks a lot for all your
kind support throughout. :) it's really make my job simpler.*
*
*
*
*
*Thanks & Regards,*
*Indrajit*
*
*
On Wed, Oct 3, 2012 at 7:27 PM, Indrajit $nai wrote:
> *@ Krishna, waiting for your reply. :
*@ Krishna, waiting for your reply. :)*
On Wed, Oct 3, 2012 at 1:13 AM, Indrajit $nai wrote:
> *@ Krishna, no Sir; still showing the same error!
> *
>
>
>
> On Tue, Oct 2, 2012 at 9:26 PM, Krishna Kumar wrote:
>
>> .Range("b" & LastR
*Congrats bro. :)*
*
*
On Wed, Oct 3, 2012 at 11:35 AM, SAGAR KASANGOTTUWAR <
sagarkasangottu...@gmail.com> wrote:
> Congrats Rajan
>
>
> On Wed, Oct 3, 2012 at 10:36 AM, Karan Singh wrote:
>
>> Congrats dude!
>>
>>
>> Karan Singh
>>
>>
>>
>>
>> On Wed, Oct 3, 2012 at 10:24 AM, Aamir Sha
*@ Krishna, but Sir, still it's showing the same error!!!*
On Tue, Oct 2, 2012 at 4:10 PM, Krishna Kumar wrote:
> in this line it should be 3
>
> .Range("b" & LastRow).Resize(, 3)
>
> in your code it's 4
>
> Kris
>
> Kris
> ExcelFox
>
> --
> Join official facebook page of this forum @
> https
*@ Krishna, thanks a lot Sir. Lemme try this :)*
On Fri, Sep 28, 2012 at 9:51 PM, Krishna Kumar wrote:
> Hi
>
> Replace the commandbutton1 code with this one.
>
> Private Sub CommandButton1_Click()
> Dim wbkActive As Workbook
> Dim FilePathAs String
> Dim FileNameAs S
*@ Krishna, Sir I'm waiting for your reply. :)*
*
*
On Thu, Sep 27, 2012 at 2:38 AM, Indrajit $nai wrote:
*@ Krishna, Sir I'm waiting for your reply. :)*
>
>
> On Tue, Sep 25, 2012 at 11:16 PM, Indrajit $nai
> wrote:
>
>> *@ Krishna, thanks for the reply,
*@ Krishna, Sir I'm waiting for your reply. :)*
On Tue, Sep 25, 2012 at 11:16 PM, Indrajit $nai wrote:
> *@ Krishna, thanks for the reply, It working now, but some issue;*
> *
> *
> *1. Through this Master file I'm able to create the slave files, but it's
>
t; Rajan verma
> >
> > +91 7838100659 [IM-Gtalk]
> >
> >
> >
> > From: excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com]
> > On Behalf Of Indrajit $nai
> > Sent: 25 September 2012 8:48
> > To: excel-ma
ohibited and may
> be unlawful.
>
> ** **
>
> ** **
>
> On Tue, Sep 25, 2012 at 8:39 PM, Rajan_Verma
> wrote:
>
> *Can you explain what you actually want to do?*
>
> * *
>
> * *
>
> * *
>
> *Regards*
>
> *R
gt; *Can you explain what you actually want to do?*
>
> * *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *I
Hi All,
This is just my curiosity; can we broadcast any message through a shared
excel file to the other user at the same time, when they are using that
file….. J
Is it possible through VBA???
Thanks & Regards,
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are
2012 at 3:22 PM, Indrajit $nai wrote:
> Thanks *Krishna*, thanks a lot. :)
>
> it's a gr8 solution. :)
>
> --
> Indrajit
>
> Disclaimer:
> This electronic message and any files transmitted with it are confidential
> and intended solely for the use of the
d do necessary changes.
>
>
>
> On Sun, Sep 23, 2012 at 1:27 PM, Indrajit $nai
> wrote:
> > @Group, @ Rajan, @ Don - any solution?
> >
> > Thanks & Regards,
> > Indrajit
> >
> >
> >
> > On Sun, Sep 23, 2012 at 12:04 AM, Indrajit $nai
*@Group, @ Rajan, @ Don - any solution?*
Thanks & Regards,
Indrajit
On Sun, Sep 23, 2012 at 12:04 AM, Indrajit $nai wrote:
> *@ Rajan, *Yes there are 200 files with the same format. I can do the
> consolidation part through VBA, it's not a problem.
>
> It will be li
;
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 22 September 2012 7:13
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Requi
*Congrats Noorain. :)*
*
*
*
*
On Mon, Sep 3, 2012 at 11:59 AM, Rakesh Kumar Sharma wrote:
> Hi Noorain,
>
> Great job Dear,
> Congratulations !!!
>
>
>
> On Mon, Sep 3, 2012 at 10:40 AM, Seraj Alam wrote:
>
>> congrats noorain bhai.
>>
>>
>> On Mon, Sep 3, 2012 at 10:35 AM, अनिल नारायण ग
Hi All,
Can we track through VBA, how many time I've opened a particular file in a
day?
If it's possible then please provide me the VBA code.
Thanks in advance.
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use
Congrats Noorain. :)
On Sat, Aug 4, 2012 at 5:20 PM, jmothilal wrote:
> Thanks with Congrats Noorain.
>
> Mothilal.J
>
> On Sat, Aug 4, 2012 at 4:16 AM, dguillett1 wrote:
>
>> Good work!
>>
>> Don Guillett
>> Microsoft Excel Developer
>> SalesAid Software
>> dguille...@gmail.com
>>
>>
Thanks a lot Noorain. :)
On Fri, Jul 20, 2012 at 9:52 AM, NOORAIN ANSARI wrote:
> Dear Indrajit,
>
> PFA
>
>
> On Fri, Jul 20, 2012 at 9:48 AM, Indrajit $nai wrote:
>
>> Thanks Noorain, but please send me the Answer paper also. :)
>>
>>
>> On
Thanks Noorain, but please send me the Answer paper also. :)
On Fri, Jul 20, 2012 at 8:07 AM, NOORAIN ANSARI wrote:
> Dear Indrajit,
>
> See attached sheet, Hope it hlep to you.
>
>
> On Fri, Jul 20, 2012 at 2:04 AM, Indrajit $nai wrote:
>
>>
>> Hi All,
&
Hi All,
Can some one provide me some set of MS Excel (Practical
and Theoretical) question for interview.
Thanks in advance.
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom the
Thanks a lot @ Noorain. :)
On Wed, Jul 18, 2012 at 9:32 PM, NOORAIN ANSARI wrote:
>
>
> On Wed, Jul 18, 2012 at 3:09 AM, Indrajit $nai wrote:
>
>> Hi All,
>>
>> Tell me some easiest way to learn/understand INDEX, INDIRECT, FIND,
>> MATCH, OFFSE
Thanks buddy.
On Wed, Jul 18, 2012 at 10:55 PM, Prince Dubey wrote:
> Hi Indrajit,
>
> I thing this site will help you
> http://www.ozgrid.com/
> regards
> prince dubey
>
> On Wednesday, July 18, 2012 3:09:11 AM UTC+5:30, Bullet wrote:
>>
>> Hi All,
>>
>> Tell me some easiest way to learn/un
Thanks to everyone.but can you send me some example file with the
attachment.
On Wed, Jul 18, 2012 at 4:34 PM, pankaj sangotra wrote:
> Go to techonthenet website, it will surely help u out buddy
> On Jul 18, 2012 3:09 AM, "Indrajit $nai" wrote:
>
>> Hi All,
>&
Hi All,
Tell me some easiest way to learn/understand INDEX, INDIRECT, FIND, MATCH,
OFFSET functions.
Thanks in advance.
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they
ar
*Congrats..Ashish & Dilip*. :)
On Thu, Jul 5, 2012 at 11:05 AM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
> cong both of you
>
> Regards,
>
> Sanjib
>
>
>
> On Wed, Jul 4, 2012 at 8:45 PM, Divaker Pandey wrote:
>
>> *Congrats..Ashish & Dilip, for your gr8 Achievement.*
>>
>> B
Congrats Asish. :)
On Tue, Jul 3, 2012 at 8:27 PM, Bé Trần Văn wrote:
> Show group already have 03 users received decode of the
> Microsoft, real absolute. I am tham community this because it very useful to
> add comments expression cho me also like all all user.
> Sorry,
Hi All,
Can someone provide me some VBA Question for interview.
Thanks in advance.
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they
are addressed. If you are not the inten
show.
>>
>> Hope it will help to you.
>>
>>
>>
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>> On Thu, Jun 21, 2012 at 12:44 AM, Indrajit $nai
>> wrote:
>>
&
@Dear Noorain,
In one of your Dashboard sample file (DASHBOARD REPORT-BROKERAGE-V2.5) all
the sheets are hidden but links are working, can you please explain how to
create this kind of file.
Thanks in advance.
Thanks & Regards,
Indrajit
On Tue, Jun 19, 2012 at 10:15 PM, pankaj gmail account wrot
pot.com
>
> On Mon, Jun 11, 2012 at 9:40 AM, Indrajit $nai wrote:
>
>> *@Noorain, is this option available in MS Excel 2007? If yes, then can
>> you please send a snapshot for exact location, because I am not getting
>> this option in my MS Excel 2007.*
>>
>>
*@Noorain, is this option available in MS Excel 2007? If yes, then can you
please send a snapshot for exact location, because I am not getting this
option in my MS Excel 2007.*
On Fri, Jun 8, 2012 at 7:24 AM, NOORAIN ANSARI wrote:
> Dear Mangesh,
>
> Goto to Excel Option-Fomula-Uncheck Use GetP
Congrats Rajan. :D
On Mon, Jun 4, 2012 at 6:06 PM, Rajan_Verma wrote:
> Thank you all J
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *resp...@gm
Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* Thursday, May 31, 2012 7:08 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Require Business related PPT pr
Dear Noorian,
Can you please send me those ebooks to my mail id: talk2indra...@gmail.com
Thanks in advance.
On Thu, May 31, 2012 at 4:44 PM, Prakash Paul wrote:
> Dear Noorian,
>
> Please send the 2007 file to jprakashp...@gmail.com.
>
> Thanks in advance
>
> Regards
> Paul
>
>
> --
> FORUM R
M-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 31 May 2012 7:38
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Require Business related PPT presentation
Hi All,
Can anyone share some Business related PPT presentation template!!!
Thanks in advance.
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they
are addressed. If you are n
A1").Value=Evaluate("=Index(D1:E5,Match(1,D1:D5,0),2)")*
>
> ** **
>
> ** **
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
>
ma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 14 May 2012 7:13
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ How to
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 14 May 2012 3:53
> *To:* excel-macros@googlegroups.com
>
an verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 14 May 2012 4:17
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ How to
Hi All,
Can anyone explain how to use Vlookup, Index, Match, Offset function in VBA
Coading
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they
are addressed. If you a
> StartTIme = Empty
>
> EndTime = Empty****
>
> End Sub
>
> ** **
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@goog
> blnFlag = True
>
> Application.OnTime Now + TimeValue("00:01:00"), "StartTimer"
>
> End If
>
> End Sub
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
&
xcel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 05 May 2012 03:57
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in
> Excel (Only for numeric keys)?
>
> **
Hi All,
Can we calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?
Can anyone have Typing Practice kind of Macro in Excel, through that we can
measure our typing speed?
If anyone have this kind of thing then please send me the same.
Thanks in advance.
--
Indrajit
talk2indra.
Congrats Ayush.it's a gr8 achievement.
On Sun, Mar 25, 2012 at 4:10 PM, Dilip Pandey wrote:
> Congratulations.. Ayush.. this groups is awesome.
>
> Best of luck.
>
> Regards,
> DILIPandey
>
> On 3/22/12, Ayush Jain wrote:
> >
> >
> > Dear members,
> >
> >
> >
> > I am proud to announce
rim(Target)) > 0 Then _
> Target.Offset(, 1) = Now
> End If
> End Sub
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Indrajit $nai
> *Sent:* Thursday, March 22, 2012 1:23 AM
> *To:* excel-macros@googlegroups.com
> *Subjec
Hi All,
Need a small help from you all. I have attached a file with this mail. Now
if you open the file you can see there is a button named Login, if you
click on it, it will take the system time and date.
There are two columns available, Name (Column A) and Login Time (Column B),
now I want if t
Thanks Don.
On Mon, Mar 12, 2012 at 2:38 AM, dguillett1 wrote:
> try custom format of
>
> h
> or
> [$-409]h;@
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Indrajit $nai
> *Sent:* Sunday, Marc
Hi All,
Need a small help, can anyone convert the below mention format into the
Hour?
3/12/2012 2:21 Should be only 2.
Is there any formula? if its present then please provide me the same.
Thanks in advance.
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are
Thanks.
On Thu, Feb 23, 2012 at 3:22 AM, ChilExcel wrote:
> check whether this help
>
> http://www.rondebruin.nl/key.htm
>
> Thanks
>
>
> Chilexcel
>
> 2012/2/22, Indrajit $nai :
> > Hi All,
> >
> > Is there any coding is available which can c
Hi All,
Is there any coding is available which can capture the "Keystroke" in a
Excel file, Like whenever I am pressing alt+ctrl+del or locking the system
it will automatically capture the timing in a Excel file. If the coding is
available then please provide me the same.
Thanks in advance for al
Hi All,
Is there any coding is available which can capture the "Keystroke" in a
Excel file, Like whenever I am pressing alt+ctrl+del or locking the system
it will automatically capture the timing in a Excel file. If the coding is
available then please provide me the same.
Thanks in advance for al
Sam Mathai Chacko
>
>
> On Sat, Jan 7, 2012 at 2:38 PM, JAVED KHAN wrote:
>
>> it has some kind of excel sheet setting..so go into option
>>
>>
>> On Sat, Jan 7, 2012 at 4:22 AM, Indrajit $nai wrote:
>>
>>> Hi All,
>>>
>>> I got t
Hi All,
I got the attached file somewhere from net. Can anyone explain me how to
create such kind of workbook like the attached file.
Thanks in advance.
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the ind
file name, etc
>
>='C:\aa\[3.xls]Sheet24'!A3
>
>='C:\Users\Administrator\Desktop\05112012\[1.xls]sheet1'!a1
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Indrajit $nai
> *Sent:* Tuesday, November 01, 2011 4:36 PM
&
Hi All,
I need your help regarding a macro issue. Suppose I have 5 folder in
different in my
computer desktop and each folder contains a excel file (same name).
Now I want a macro which will open each folder and then open the file and
will copy the
first cell then paste it in my current file cell
Hi All,
I need your help regarding a macro issue. Suppose I have 5 folder in
different in my
computer desktop and each folder contains a excel file (same name).
Now I want a macro which will open each folder and then open the file and
will copy the
first cell then paste it in my current file cell
logspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
> On Fri, Oct 28, 2011 at 1:15 AM, Indrajit $nai wrote:
>
>> Hi All,
>>
>> Can anyone tell me the simplified / easiest way to learn Index, Match and
>> Offset - formulas or arra
Hi All,
Can anyone tell me the simplified / easiest way to learn Index, Match and
Offset - formulas or arrays, with some example.
Thanks in advance.
--
Indrajit Snai
talk2indra...@gmail.com
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended sole
logspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
> On Thu, Oct 27, 2011 at 1:01 AM, Indrajit $nai wrote:
>
>> Hi All,
>>
>> Can some one provide me some MIS template, like production analysis,
>> quality analy
1 - 100 of 114 matches
Mail list logo
