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
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
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
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
@googlegroups.com] *On Behalf Of *Indrajit $nai
*Sent:* Wednesday, May 28, 2014 5:07 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Need a small help in VBA coding
Hi All,
I just need a small favor from your end, please have a look at the code I
have explained everything over
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 rowx and columns E-L
I already managed to getelementbyid from
Thanks a lot Jayavelu. :)
*Thanks! Indrajit*
On Thu, Mar 13, 2014 at 1:01 PM, JAYAVELU SUN jayavelu@gmail.comwrote:
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 talk2indra
Thanks Shahzad.
On Mon, Mar 17, 2014 at 12:04 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
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)-1))
On Mon, Mar 17, 2014 at 12:32 AM, Indrajit $nai
talk2indra
Thanks Ashish.
On Sun, Mar 16, 2014 at 8:56 PM, ashish koul koul.ash...@gmail.com wrote:
then try left and find function combined
On Sun, Mar 16, 2014 at 1:02 AM, Indrajit $nai talk2indra...@gmail.comwrote:
Yes Ashish...
On Sat, Mar 15, 2014 at 3:39 PM, ashish koul koul.ash
Yes Ashish...
On Sat, Mar 15, 2014 at 3:39 PM, ashish koul koul.ash...@gmail.com wrote:
is ACT common in all
On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai talk2indra...@gmail.comwrote:
Hi Experts,
Is there any way out to split up an address as per the attached file
format!
If so
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
of months back
Regards,
Priyanka S
On Sat, Dec 14, 2013 at 10:32 PM, Indrajit $nai
talk2indra...@gmail.comwrote:
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
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)
amit.de...@merucabs.comwrote:
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 2013 13:45
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
@googlegroups.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 no. and Cell Ph No. along with the other
:00 AM, Ravinder ravinderexcelgr...@gmail.comwrote:
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 PM
*To:* excel-macros
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
-macros@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 was my mistake, I don't wanna count it, I want
=sumup(b2) and
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 formula
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
.
On Tue, Sep 24, 2013 at 2:21 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
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@googlegroups.com
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 talk2indra...@gmail.comwrote:
Thanks a lot bro
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 talk2indra...@gmail.comwrote:
Hi Experts,
I am facing some problem with this macro file, actually the macro is
running pretty well
@googlegroups.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!!!
** **
Just need
!!
On Mon, Jul 1, 2013 at 12:21 AM, Indrajit $nai talk2indra...@gmail.comwrote:
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
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
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
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
, xlstime xlst...@gmail.com wrote:
try this
http://www.free-training-tutorial.com/
On Mon, Mar 4, 2013 at 8:35 PM, Indrajit $nai
talk2indra...@gmail.com wrote:
Hi all,
please provide me some basic training materials of Excel .
thanks in advance.
--
Indrajit
talk2indra...@gmail.com
Sorry attached wrong file, in my previous mail...
On Tue, Feb 19, 2013 at 8:09 PM, Indrajit $nai talk2indra...@gmail.comwrote:
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
.” - John Wesley
*-
--
*From:* Indrajit $nai talk2indra...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Tue, February 19, 2013 3:13:23 PM
*Subject:* $$Excel-Macros$$ Re: Login and Logout time tracker...need
help
*-
--
*From:* Indrajit $nai talk2indra...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Tue, February 19, 2013 5:12:33 PM
*Subject:* Re: $$Excel-Macros$$ Re: Login and Logout time tracker...need
help
Hi Paul,
There is one problem, whenever I'm opening any new excel
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
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
*@ 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 talk2indra...@gmail.comwrote:
*@ Krishna, waiting for your reply
*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 karan1...@gmail.com wrote:
Congrats dude!
Karan Singh
On Wed, Oct 3, 2012 at 10:24 AM, Aamir Shahzad
*@ Krishna, waiting for your reply. :)*
On Wed, Oct 3, 2012 at 1:13 AM, Indrajit $nai talk2indra...@gmail.comwrote:
*@ Krishna, no Sir; still showing the same error!
*
On Tue, Oct 2, 2012 at 9:26 PM, Krishna Kumar krishnak...@gmail.comwrote:
.Range(b LastRow).Resize(, 4
*@ Krishna, but Sir, still it's showing the same error!!!*
On Tue, Oct 2, 2012 at 4:10 PM, Krishna Kumar krishnak...@gmail.com 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 @
*@ Krishna, thanks a lot Sir. Lemme try this :)*
On Fri, Sep 28, 2012 at 9:51 PM, Krishna Kumar krishnak...@gmail.comwrote:
Hi
Replace the commandbutton1 code with this one.
Private Sub CommandButton1_Click()
Dim wbkActive As Workbook
Dim FilePathAs String
Dim
*@ Krishna, Sir I'm waiting for your reply. :)*
*
*
On Thu, Sep 27, 2012 at 2:38 AM, Indrajit $nai talk2indra...@gmail.comwrote:
*@ Krishna, Sir I'm waiting for your reply. :)*
On Tue, Sep 25, 2012 at 11:16 PM, Indrajit $nai
talk2indra...@gmail.comwrote:
*@ Krishna, thanks
*@ Krishna, Sir I'm waiting for your reply. :)*
On Tue, Sep 25, 2012 at 11:16 PM, Indrajit $nai talk2indra...@gmail.comwrote:
*@ 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
not opening
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
...@gmail.comwrote:
*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 *Indrajit $nai
*Sent:* 25 September 2012 8:31
*To:* excel
Of *Indrajit $nai
*Sent:* 25 September 2012 8:48
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Broadcasting messages through Excel...
** **
Ok, I think you know how Windows Broadcating messages works in LAN through
Telnet . :)
** **
Suppose 10 users
Of Indrajit $nai
Sent: 25 September 2012 8:48
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Broadcasting messages through Excel...
Ok, I think you know how Windows Broadcating messages works in LAN
through
Telnet . :)
Suppose 10 users is working
*@Group, @ Rajan, @ Don - any solution?*
Thanks Regards,
Indrajit
On Sun, Sep 23, 2012 at 12:04 AM, Indrajit $nai talk2indra...@gmail.comwrote:
*@ 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 like
on this and do necessary changes.
On Sun, Sep 23, 2012 at 1:27 PM, Indrajit $nai talk2indra...@gmail.com
wrote:
@Group, @ Rajan, @ Don - any solution?
Thanks Regards,
Indrajit
On Sun, Sep 23, 2012 at 12:04 AM, Indrajit $nai talk2indra...@gmail.com
wrote:
@ Rajan, Yes
, Indrajit $nai talk2indra...@gmail.comwrote:
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 individual or entity to whom
]*
* *
*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$$ Required help in Work Allocation VBA based
excel file.
** **
Hi All,
** **
I
*Congrats Noorain. :)*
*
*
*
*
On Mon, Sep 3, 2012 at 11:59 AM, Rakesh Kumar Sharma rakeshks@gmail.com
wrote:
Hi Noorain,
Great job Dear,
Congratulations !!!
On Mon, Sep 3, 2012 at 10:40 AM, Seraj Alam seraj.ala...@gmail.comwrote:
congrats noorain bhai.
On Mon, Sep 3,
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 gjmothi...@gmail.com wrote:
Thanks with Congrats Noorain.
Mothilal.J
On Sat, Aug 4, 2012 at 4:16 AM, dguillett1 dguille...@gmail.com wrote:
Good work!
Don Guillett
Microsoft Excel Developer
SalesAid Software
Thanks a lot Noorain. :)
On Fri, Jul 20, 2012 at 9:52 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Indrajit,
PFA
On Fri, Jul 20, 2012 at 9:48 AM, Indrajit $nai talk2indra...@gmail.comwrote:
Thanks Noorain, but please send me the Answer paper also. :)
On Fri, Jul 20
Thanks a lot @ Noorain. :)
On Wed, Jul 18, 2012 at 9:32 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
On Wed, Jul 18, 2012 at 3:09 AM, Indrajit $nai talk2indra...@gmail.comwrote:
Hi All,
Tell me some easiest way to learn/understand INDEX, INDIRECT, FIND,
MATCH, OFFSET functions
Thanks Noorain, but please send me the Answer paper also. :)
On Fri, Jul 20, 2012 at 8:07 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Indrajit,
See attached sheet, Hope it hlep to you.
On Fri, Jul 20, 2012 at 2:04 AM, Indrajit $nai talk2indra...@gmail.comwrote:
Hi All
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 psangotr...@gmail.comwrote:
Go to techonthenet website, it will surely help u out buddy
On Jul 18, 2012 3:09 AM, Indrajit $nai talk2indra...@gmail.com wrote
Thanks buddy.
On Wed, Jul 18, 2012 at 10:55 PM, Prince Dubey prince141...@gmail.comwrote:
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
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
*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 divake...@gmail.comwrote:
*Congrats..Ashish Dilip, for your gr8 Achievement.*
Congrats Asish. :)
On Tue, Jul 3, 2012 at 8:27 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote:
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
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
,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Thu, Jun 21, 2012 at 12:44 AM, Indrajit $nai
talk2indra...@gmail.comwrote:
@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
@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
, 2012 at 9:40 AM, Indrajit $nai talk2indra...@gmail.comwrote:
*@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
*@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 noorain.ans...@gmail.comwrote:
Dear Mangesh,
Goto to Excel
Congrats Rajan. :D
On Mon, Jun 4, 2012 at 6:06 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Thank you all J
** **
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of
-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 presentation
template.
** **
Hi All,
Can anyone share
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
-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
template.
** **
Hi All,
Can anyone share some Business
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 jprakashp...@gmail.comwrote:
Dear Noorian,
Please send the 2007 file to jprakashp...@gmail.com.
Thanks in advance
Regards
Paul
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
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 calculate WPM (Word Per Minute) in
Excel (Only for numeric
***
** **
** **
* *
*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
*Subject:* $$Excel-Macros$$ Vlookup, Index, Match, Offset function
[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 calculate WPM (Word Per Minute) in
Excel (Only for numeric keys
:D5,0),2))*
** **
** **
** **
* *
*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 7:15
*To:* excel-macros@googlegroups.com
*Subject:* Re
) Second
Time, vbInformation
StartTIme = Empty
EndTime = Empty
End Sub
** **
** **
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
*Sent
:
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
** **
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
*Sent:* 11 May 2012 4:40
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ How
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
Congrats Ayush.it's a gr8 achievement.
On Sun, Mar 25, 2012 at 4:10 PM, Dilip Pandey dilipan...@gmail.com wrote:
Congratulations.. Ayush.. this groups is awesome.
Best of luck.
Regards,
DILIPandey
On 3/22/12, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
I
Then _
Target.Offset(, 1) = Now
End If
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* Indrajit $nai talk2indra...@gmail.com
*Sent:* Thursday, March 22, 2012 1:23 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Need a small
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
Thanks Don.
On Mon, Mar 12, 2012 at 2:38 AM, dguillett1 dguille...@gmail.com wrote:
try custom format of
h
or
[$-409]h;@
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* Indrajit $nai talk2indra...@gmail.com
*Sent:* Sunday, March 11, 2012 3:52
Thanks.
On Thu, Feb 23, 2012 at 3:22 AM, ChilExcel chilexcel...@gmail.com wrote:
check whether this help
http://www.rondebruin.nl/key.htm
Thanks
Chilexcel
2012/2/22, Indrajit $nai talk2indra...@gmail.com:
Hi All,
Is there any coding is available which can capture
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 all
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 all
at 2:38 PM, JAVED KHAN john.he.ma...@gmail.comwrote:
it has some kind of excel sheet setting..so go into option
On Sat, Jan 7, 2012 at 4:22 AM, Indrajit $nai talk2indra...@gmail.comwrote:
Hi All,
I got the attached file somewhere from net. Can anyone explain me how to
create such kind
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
in the 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 talk2indra...@gmail.com
*Sent:* Tuesday, November 01, 2011 4:36 PM
*To:* excel-macros@googlegroups.com
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
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
-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Fri, Oct 28, 2011 at 1:15 AM, Indrajit $nai talk2indra...@gmail.comwrote:
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
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
:
excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Friday, August 19, 2011 9:20 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula.
try this
On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai talk2indra...@gmail.com
koul
Sent: Friday, August 19, 2011 9:20 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula.
try this
On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai talk2indra...@gmail.com
wrote:
Hi All,
I need your small help in Vlookup
Hi All,
I need your small help in Vlookup formula. I have attached a file with this
mail, where you can see 2 columns in the left. One is Qty. another is Sr.
no.
Now I want to search Sr. no. through Qty. Suppose if I put Qty. 1400 it will
show me 14, if I put 600 it will show 6, but the problem
Sub
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
*Sent:* Monday, May 30, 2011 3:12 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Requesting for a small help in vba coding
Hi All,
I need a small
Hi All,
I have a little query in vba coding, please see the attached file. In the
excel file there is a Save command button, whenever I press the button it
will copy the data from cell no. c1:d1 and paste in the cell a1:b1, now my
query is, if the data is already in the cell no. a1:b1 it will be
Congrats Dear..
On Sun, Mar 20, 2011 at 10:18 PM, Dhananjay Pinjan dppin...@gmail.comwrote:
Thousand time Congratulation dear Ayush. This forum will definately played
a very vital role for whom those are very eager to know the Excel.
Thanks for your always support to the members
1 - 100 of 104 matches
Mail list logo