$$Excel-Macros$$ Kindly assist with a formula !!!

2016-11-12 Thread Indrajit $nai
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

$$Excel-Macros$$ Need help with excel formula !!!

2016-07-17 Thread Indrajit $nai
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

$$Excel-Macros$$ Automatic color for excel chart levels

2015-09-15 Thread Indrajit $nai
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

$$Excel-Macros$$ Data mapping tutorials

2015-01-13 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Need a small help in VBA coding

2014-05-28 Thread Indrajit $nai
@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

$$Excel-Macros$$ Need a small help in VBA coding

2014-05-27 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Need an address split up formula.....

2014-03-26 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Need an address split up formula.....

2014-03-17 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Need an address split up formula.....

2014-03-16 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Need an address split up formula.....

2014-03-15 Thread Indrajit $nai
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

$$Excel-Macros$$ Need an address split up formula.....

2014-03-12 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Need a professional MIS Report.....

2013-12-15 Thread Indrajit $nai
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

$$Excel-Macros$$ Need a professional MIS Report.....

2013-12-14 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ How do I decrease the size of this file.....

2013-12-08 Thread Indrajit $nai
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

$$Excel-Macros$$ Need help to create a Purchase Order database.....

2013-11-22 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Need PDF to Excel Converter.....

2013-11-09 Thread Indrajit $nai
@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

Re: $$Excel-Macros$$ Need PDF to Excel Converter.....

2013-11-07 Thread Indrajit $nai
: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

$$Excel-Macros$$ Help required in a small formula.....

2013-10-11 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Help required in formula.....

2013-10-04 Thread Indrajit $nai
-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

Re: $$Excel-Macros$$ Help required in formula.....

2013-10-03 Thread Indrajit $nai
=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

$$Excel-Macros$$ Help required in formula.....

2013-10-02 Thread Indrajit $nai
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

Re: FW: $$Excel-Macros$$ Need experts help ***URGENT***

2013-09-25 Thread Indrajit $nai
. 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

Re: $$Excel-Macros$$ Need experts help ***URGENT***

2013-09-23 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Need experts help ***URGENT***

2013-09-19 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Need experts help ***URGENT***

2013-09-19 Thread Indrajit $nai
@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

Re: $$Excel-Macros$$ Validation through Macro!!!

2013-07-07 Thread Indrajit $nai
!! 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

$$Excel-Macros$$ Validation through Macro!!!

2013-06-30 Thread Indrajit $nai
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

$$Excel-Macros$$ Need some Defect chart / Control chart.....

2013-03-13 Thread Indrajit $nai
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

$$Excel-Macros$$ please provide me some basic training materials of Excel

2013-03-04 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ please provide me some basic training materials of Excel

2013-03-04 Thread Indrajit $nai
, 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

$$Excel-Macros$$ Re: Login and Logout time tracker...need help....

2013-02-19 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Re: Login and Logout time tracker...need help....

2013-02-19 Thread Indrajit $nai
.” - 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

Re: $$Excel-Macros$$ Re: Login and Logout time tracker...need help....

2013-02-19 Thread Indrajit $nai
*- -- *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

$$Excel-Macros$$ Web page import / export through macro !!!!!

2012-12-08 Thread Indrajit $nai
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

$$Excel-Macros$$ File conversion from BMP to XLS !!!!!

2012-12-06 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2012-10-07 Thread Indrajit $nai
*@ 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

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012

2012-10-03 Thread Indrajit $nai
*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

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2012-10-03 Thread Indrajit $nai
*@ 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

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2012-10-02 Thread Indrajit $nai
*@ 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 @

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2012-09-29 Thread Indrajit $nai
*@ 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

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2012-09-28 Thread Indrajit $nai
*@ 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

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2012-09-26 Thread Indrajit $nai
*@ 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

$$Excel-Macros$$ Broadcasting messages through Excel...

2012-09-25 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Broadcasting messages through Excel...

2012-09-25 Thread Indrajit $nai
...@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

Re: $$Excel-Macros$$ Broadcasting messages through Excel...

2012-09-25 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Broadcasting messages through Excel...

2012-09-25 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2012-09-23 Thread Indrajit $nai
*@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

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2012-09-23 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2012-09-23 Thread Indrajit $nai
, 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

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

2012-09-22 Thread Indrajit $nai
]* * * *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

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

2012-09-03 Thread Indrajit $nai
*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,

$$Excel-Macros$$ How many time I've opened a particular file in a day?

2012-08-29 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-04 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Required some MS Excel question for interview.

2012-07-20 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?

2012-07-19 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Required some MS Excel question for interview.

2012-07-19 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?

2012-07-18 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Re: How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?

2012-07-18 Thread Indrajit $nai
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

$$Excel-Macros$$ How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?

2012-07-17 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

2012-07-05 Thread Indrajit $nai
*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.*

Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******

2012-07-04 Thread Indrajit $nai
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

$$Excel-Macros$$ Need some VBA Question for interview.

2012-06-27 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Re: share Dashboard Examples/Templates

2012-06-21 Thread Indrajit $nai
, 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

Re: $$Excel-Macros$$ Re: share Dashboard Examples/Templates

2012-06-20 Thread Indrajit $nai
@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

Re: $$Excel-Macros$$ Need Help

2012-06-11 Thread Indrajit $nai
, 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

Re: $$Excel-Macros$$ Need Help

2012-06-10 Thread Indrajit $nai
*@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

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)

2012-06-05 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Require Business related PPT presentation template.....

2012-06-03 Thread Indrajit $nai
-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

$$Excel-Macros$$ Require Business related PPT presentation template.....

2012-05-31 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Require Business related PPT presentation template.....

2012-05-31 Thread Indrajit $nai
-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

Re: $$Excel-Macros$$ MACRO

2012-05-31 Thread Indrajit $nai
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

$$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

2012-05-14 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?

2012-05-14 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

2012-05-14 Thread Indrajit $nai
*** ** ** ** ** * * *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

Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?

2012-05-14 Thread Indrajit $nai
[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

Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

2012-05-14 Thread Indrajit $nai
: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

Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?

2012-05-13 Thread Indrajit $nai
) 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

Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?

2012-05-11 Thread Indrajit $nai
: 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

Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?

2012-05-11 Thread Indrajit $nai
** ** * * *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

$$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?

2012-05-04 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******

2012-03-25 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro.....

2012-03-22 Thread Indrajit $nai
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

$$Excel-Macros$$ Need a small help, related to the Date and Time macro.....

2012-03-20 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Need a small help

2012-03-11 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Looking for a Macro which can capture the keystroke timing....

2012-02-23 Thread Indrajit $nai
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

$$Excel-Macros$$ Looking for a Macro which can capture the keystroke timing....

2012-02-22 Thread Indrajit $nai
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

$$Excel-Macros$$ Looking for a Macro which can capture the keystroke timing....

2012-02-20 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Multiple worksheet in a single file.....need some help

2012-01-07 Thread Indrajit $nai
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

$$Excel-Macros$$ Multiple worksheet in a single file.....need some help

2012-01-06 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Required help in macro / vba coding........open a file in a particular folder

2011-11-02 Thread Indrajit $nai
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

$$Excel-Macros$$ Required help in macro / vba coding........open a file in a particular folder

2011-11-01 Thread Indrajit $nai
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

$$Excel-Macros$$ Required help in macro / vba coding........open a file in a particular folder

2011-11-01 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Want to learn Match and Offset - formulas

2011-10-28 Thread Indrajit $nai
-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

$$Excel-Macros$$ Want to learn Match and Offset - formulas

2011-10-27 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-20 Thread Indrajit $nai
: 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

Re: $$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-19 Thread Indrajit $nai
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

$$Excel-Macros$$ Need your help in Vlookup formula.....

2011-08-18 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ Requesting for a small help in vba coding....

2011-05-31 Thread Indrajit $nai
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

$$Excel-Macros$$ A small query, need your help in vba coding.

2011-05-06 Thread Indrajit $nai
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

Re: $$Excel-Macros$$ discussexcel.com Launched today

2011-03-20 Thread Indrajit $nai
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   2   >