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

2012-07-02 Thread pankaj gmail account
Dear Moderator, Please also Ban these kinds of Promotional/Advertisements in this forum. They are not related to Excel Help. Please advice Thanks and Regads, Pankaj Michael On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain wrote: > Dear members, > > I am extremely happy to inform you that two memb

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

2012-07-02 Thread Deba Ranjan
Dear Ashish and Dilip. Sorry for the delay, its a really awesome stage. heartiest congratulate to both and please keep helping to this group. Thanks & Regards, *Deba Ranjan P* On Mon, Jul 2, 2012 at 9:23 PM, vijayajith VA wrote: > CongratsASHISH *DILIP... > > > On Mon, Ju

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

2012-07-02 Thread Mohammed Muneer
Good Mornings Dear Ashish & Dilip Congrats for both of you, have a nice journey in future and greater the talents. Prayers & Blessings, Muneer, CC... . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, lik

RE: $$Excel-Macros$$ What do you recommend?? If Formulas, Tables with macros, vlookups?

2012-07-02 Thread Asa Rossoff
Hi Jorge, I am happy to help you. > the table in the example transporter AA the volumes are the columns "1", "2 to 3", and "4 to 5", the column below is the weight, but there are some rules, imagine we have zone 1, but the kg are 8 but the volumes are 1, i´m must charge 2 instead of one, because

$$Excel-Macros$$ Re: DASHBOARD FOR STOCK MARKET REVIEW

2012-07-02 Thread Prince Dubey
Hi Hilary, It is looking very good. But i need some of the information about this what exactly it is predicting. regards Prince On Thursday, 9 February 2012 20:27:51 UTC+5:30, hilary lomotey wrote: > > DA > > I just completed a dashboard for stock market review and wanted to share > it to

Re: $$Excel-Macros$$ Excel VBA Training By Subject matter Experts

2012-07-02 Thread Mangesh Vimay
Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. Rule # 05 On 7/2/12, harshita desu wrote: > Medha Information research Offering In House, Online and Corporate > training on Excel VBA > > Course Highlights > > Fully handson Sessions. > > Realtime exa

$$Excel-Macros$$ Excel VBA Training By Subject matter Experts

2012-07-02 Thread harshita desu
Medha Information research Offering In House, Online and Corporate training on Excel VBA Course Highlights Fully handson Sessions. Realtime examples Interview/project support Indepth and exclusive coverage on each topic For More details, Contact us at +91 9945207350 or write us at i...@medha

Re: $$Excel-Macros$$ How to get Min rate Which is greater than zero

2012-07-02 Thread ashish koul
check the attachment see if it helps On Sun, Jul 1, 2012 at 1:34 PM, Haris wrote: > Dear Ashish, > If 2 or 3 gave the same rate then how it will index/display. for eg: if > the price of rate a and rate b is same it will index rate a only. so is > there any way to index "rate a" and "rate b" >

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

2012-07-02 Thread vijayajith VA
CongratsASHISH *DILIP... On Mon, Jul 2, 2012 at 9:18 PM, wrote: > ** > Congratulation Ashish and Dilip. > > Sandeep Chhajer. > Sent on my BlackBerry® from Vodafone > -- > *From: * Sam Mathai Chacko > *Sender: * excel-macros@googlegroups.com > *Date: *Mon,

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

2012-07-02 Thread chhajersandeep
Congratulation Ashish and Dilip. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Sam Mathai Chacko Sender: excel-macros@googlegroups.com Date: Mon, 2 Jul 2012 21:01:24 To: Reply-To: excel-macros@googlegroups.com Cc: Dilip Pandey Subject: Re: $$Excel-Macr

Re: $$Excel-Macros$$ Query on Email via macro

2012-07-02 Thread ashwani agnihotri
thank you very much for the help ashish [?] On Mon, Jul 2, 2012 at 8:52 PM, ashish koul wrote: > assuming you have table in sheet1 like > > name status email sham done a rahim done > b > Abdul done c > nAME IN cOL A > status in col B > email in Col C > > also visit http://www.rondebruin.

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

2012-07-02 Thread Sam Mathai Chacko
Excellent achievement once again by Ashish and Dilip. Kuddos to both. Regards, Sam Mathai Chacko On Mon, Jul 2, 2012 at 7:32 PM, ashish koul wrote: > Thank you all... > > > On Mon, Jul 2, 2012 at 4:39 PM, Amol Shrivastava wrote: > >> *Congratulations Ashish and Dilip...!!* >> >> -- >> Thanks &

Re: $$Excel-Macros$$ Macro to populate "Output" file

2012-07-02 Thread OJEMENI Uzoma
Thank you Ashish. The macro worked perfectly. On Mon, Jul 2, 2012 at 3:02 PM, ashish koul wrote: > try this see if it helps > > Sub create_txtfile() > Dim arv, st1 As String > Dim s As Long, j As Long, k As Long > > MyFile = "C:\Documents and Settings\user\Desktop\sample\ouputfile.txt" > 'set an

Re: $$Excel-Macros$$ Query on Email via macro

2012-07-02 Thread ashish koul
assuming you have table in sheet1 like name status email sham done a rahim done b Abdul done c nAME IN cOL A status in col B email in Col C also visit http://www.rondebruin.nl/tips.htm to know more about oulook automation whenever you change the status to done it will send a email *a

Re: $$Excel-Macros$$ Query on Email via macro

2012-07-02 Thread ashwani agnihotri
*Someone please help me on this its important* On Sun, Jul 1, 2012 at 10:17 PM, ashwani agnihotri < ashwani.agniho...@gmail.com> wrote: > i just want to send a mail with a subject plz check to the email address > in column C for the rows in column B which i mark as done. > > On Sun, Jul 1, 2012 a

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

2012-07-02 Thread ashish koul
Thank you all... On Mon, Jul 2, 2012 at 4:39 PM, Amol Shrivastava wrote: > *Congratulations Ashish and Dilip...!!* > > -- > Thanks & Regards, > > Amol Shrivastava > +91 99671 18180 > > > > > On Mon, Jul 2, 2012 at 4:35 PM, Aindril De wrote: > >> Congratulations Ashish and Dilip!! >> Your Contrib

Re: $$Excel-Macros$$ Macro to populate "Output" file

2012-07-02 Thread ashish koul
try this see if it helps Sub create_txtfile() Dim arv, st1 As String Dim s As Long, j As Long, k As Long MyFile = "C:\Documents and Settings\user\Desktop\sample\ouputfile.txt" 'set and open file for output With Sheets("Sheet1") .Range("x:x").Clear .Range("a1:a" & .Range("a1048576").End(xlUp).Row)

RE: $$Excel-Macros$$ Index Formula Help

2012-07-02 Thread Rajan_Verma
See the attached sheet. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SUDHIR VERMA Sent: 02 July 2012 10:59 To: excel-macros Subject: $$Excel-Macros$$ Index Formula Help Dear All, Please loo

RE: $$Excel-Macros$$ Macro to populate "Output" file

2012-07-02 Thread Rajan_Verma
Can you please explain with sample data. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ojemeni Uzoma Sent: 02 July 2012 12:00 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro to

Re: $$Excel-Macros$$ Re: regarding problem on vlookup function

2012-07-02 Thread Mangesh Vimay
If Sachin Tendulkar is God of Cricket then Definitely Noorain Ansari is God of Excel. On 7/2/12, NOORAIN ANSARI wrote: > Most Welcome bro.. > > I am not god, i m a simple Excel Lover like you. > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com >

Re: $$Excel-Macros$$ DASHBOARD FOR STOCK MARKET REVIEW

2012-07-02 Thread dguillett1
Nicely done. Suggest refresh of external query on opening . Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: hilary lomotey Sent: Thursday, February 09, 2012 8:57 AM To: excel-macros Subject: $$Excel-Macros$$ DASHBOARD FOR STOCK MARKET REVIEW DA I just compl

Re: $$Excel-Macros$$ DASHBOARD FOR STOCK MARKET REVIEW

2012-07-02 Thread pankaj gmail account
It is very Helpful -- Thank you for sharing Please upload more examples of Dashboards. Regards, Pankaj Michael On Fri, Feb 10, 2012 at 12:46 AM, wrote: > Its just historical stock market information for the Ghana stock exchange > and major mkt indicators. But its the idea behind in tht u can

$$Excel-Macros$$ Re: regarding problem on vlookup function

2012-07-02 Thread NOORAIN ANSARI
Most Welcome bro.. I am not god, i m a simple Excel Lover like you. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 2, 2012 at 4:47 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > You are God Noorain ansari, > > The reply is

Re: $$Excel-Macros$$ regarding problem on vlookup function

2012-07-02 Thread Amresh Maurya
use this formula =VLOOKUP(E2,$A$1:$B$6,2,FALSE) Regards Amresh On Mon, Jul 2, 2012 at 4:43 PM, Amresh Maurya wrote: > Kindly fixed table array range. > > Regards > Amresh > > On Mon, Jul 2, 2012 at 4:41 PM, Sanjib Chatterjee > wrote: >> >> Dear Sir / Madam, >> Whenever I need solution the peo

Re: $$Excel-Macros$$ regarding problem on vlookup function

2012-07-02 Thread Amresh Maurya
Kindly fixed table array range. Regards Amresh On Mon, Jul 2, 2012 at 4:41 PM, Sanjib Chatterjee wrote: > > Dear Sir / Madam, > Whenever I need solution the people in the group always help me. Now I am > facing > another problem. > > Please see the attachment. I am facing the problem which is

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

2012-07-02 Thread Amol Shrivastava
*Congratulations Ashish and Dilip...!!* -- Thanks & Regards, Amol Shrivastava +91 99671 18180 On Mon, Jul 2, 2012 at 4:35 PM, Aindril De wrote: > Congratulations Ashish and Dilip!! > Your Contributions have always been an asset to our group.. > > Hard Luck Don...!! > Your contributions hav

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

2012-07-02 Thread Aindril De
Congratulations Ashish and Dilip!! Your Contributions have always been an asset to our group.. Hard Luck Don...!! Your contributions have always been really helpful in our group.. Better luck next time!! Cheers Andy On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain wrote: > Dear members, > > I am ext

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

2012-07-02 Thread vatspoojavats
Congratulations to both of u. Regards, Pooja Sharma Sent from BlackBerry® on Airtel -Original Message- From: Ashish Bhalara Sender: excel-macros@googlegroups.com Date: Mon, 2 Jul 2012 14:35:19 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ MVP AwardCongra

Re: $$Excel-Macros$$ What do you recommend?? If Formulas, Tables with macros, vlookups?

2012-07-02 Thread Jorge Marques
HI, the table in the example transporter AA the volumes are the columns "1", "2 to 3", and "4 to 5", the column below is the weight, but there are some rules, imagine we have zone 1, but the kg are 8 but the volumes are 1, i´m must charge 2 instead of one, because the rule weight overules the other

Re: $$Excel-Macros$$ Re: Macro to copy a macro from one workbook to another

2012-07-02 Thread Divaker Pandey
I think it can not possible due to security region. but what is your purpose? Divaker On Mon, Jun 25, 2012 at 10:31 PM, Richard wrote: > Thank you very much > On Sunday, June 24, 2012 4:46:35 PM UTC-7, Richard wrote: >> >> I would like to create a macro to copy a macro from one workbooks m

Re: $$Excel-Macros$$ Need a VBA code to display name in "Last Name, First Name" format

2012-07-02 Thread Divaker Pandey
Hi Sharath, PFA, Hope it will help you. Divaker Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo Exit_Sub Dim nameIS() As String, newName As String If Target.Column = 6 And Target.Row > 6 Then If IsEmpty(Target.Value) Then Exit Sub If InStr(Target.Value,

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

2012-07-02 Thread Ashish Bhalara
Congratulation to both experts. You are the one who can inspire others, so you deserve this. Regards. Ashish Bhalara 9624111822 On Mon, Jul 2, 2012 at 2:23 PM, Amresh Maurya wrote: > Congrats. both of you dear. > > Regards > Amresh > > On Mon, Jul 2, 2012 at 2:21 PM, setu wrote: > > hey congra

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

2012-07-02 Thread Amresh Maurya
Congrats. both of you dear. Regards Amresh On Mon, Jul 2, 2012 at 2:21 PM, setu wrote: > hey congratulations to both of you.great win...god bless u both > > > On Mon, Jul 2, 2012 at 2:12 PM, Abhishek Jain > wrote: >> >> Many congratulations to Ashish ji and Dilip ji. Well deserved. >> >> >>

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

2012-07-02 Thread setu
hey congratulations to both of you.great win...god bless u both On Mon, Jul 2, 2012 at 2:12 PM, Abhishek Jain wrote: > Many congratulations to Ashish ji and Dilip ji. Well deserved. > > > On Mon, Jul 2, 2012 at 2:04 PM, सुनिता पौडेल wrote: > >> Wow congratulations to both experts !! :) >> >>

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

2012-07-02 Thread Abhishek Jain
Many congratulations to Ashish ji and Dilip ji. Well deserved. On Mon, Jul 2, 2012 at 2:04 PM, सुनिता पौडेल wrote: > Wow congratulations to both experts !! :) > > > On Mon, Jul 2, 2012 at 1:40 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> congratulation both of you >> >> Re

Re: $$Excel-Macros$$ VBA PDF books link need

2012-07-02 Thread Venkatesh Narla
Dear Noorain Ansari, Thanks a lot... Thanks, Venkatesh. On Sun, Jul 1, 2012 at 10:56 PM, NOORAIN ANSARI wrote: > Dear Venkatesh, > Hi Venkatesh, > > Download EXCEL-VBA Ebook.. > > http://search.4shared.com/q/CCAD/1/excel+vba > http://pdftop.net/excel+vba+tutorial-pdf/ > http://www.comp.nus.ed

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

2012-07-02 Thread सुनिता पौडेल
Wow congratulations to both experts !! :) On Mon, Jul 2, 2012 at 1:40 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > congratulation both of you > > Regards, > > Sanjib > > On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain wrote: > >> Dear members, >> >> I am extremely happy to inform yo

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

2012-07-02 Thread Sanjib Chatterjee
congratulation both of you Regards, Sanjib On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain wrote: > Dear members, > > I am extremely happy to inform you that two members of the group are > awarded Microsoft Most Valuable Professional Award. > My heartiest congratulations to *Ashish koul* and *Dilip

Re: $$Excel-Macros$$ VLOOKUP for last Available Date

2012-07-02 Thread Divaker Pandey
=VLOOKUP(I3,$E$2:$F$10,2,TRUE) On Mon, Jul 2, 2012 at 12:31 PM, Shaik Waheed wrote: > =vlookup(I7,$E$7:$F$14,2,1) > > > On Mon, Jul 2, 2012 at 11:32 AM, NOORAIN ANSARI > wrote: > >> Dear Manoj, >> >> Please more explain..what is your exact requirement. >> >> -- >> Thanks & regards, >> Noorain

Re: $$Excel-Macros$$ VLOOKUP for last Available Date

2012-07-02 Thread NOORAIN ANSARI
Dear Manoj, Please use.. *=LOOKUP(I8,$E$7:$F$14) * or *=INDEX($F$7:$F$14,MATCH(I8,$E$7:$E$14,1)) * or *=OFFSET($F$6,MATCH(I8,$E$7:$E$14,1),0) * see attached sheet. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 2, 2012 at 1:14 PM, Man

RE: $$Excel-Macros$$ VLOOKUP for last Available Date

2012-07-02 Thread Manoj Kukreja
Hi, @Norrrain : I have Attached Xls sheet , @Waheed : Thanks From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Monday, July 02, 2012 11:32 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VLOOKUP for last Available Dat

Re: $$Excel-Macros$$ VLOOKUP for last Available Date

2012-07-02 Thread Shaik Waheed
=vlookup(I7,$E$7:$F$14,2,1) On Mon, Jul 2, 2012 at 11:32 AM, NOORAIN ANSARI wrote: > Dear Manoj, > > Please more explain..what is your exact requirement. > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Mon, Jul 2, 2012 at 11:22 AM, Man