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

2012-07-02 Thread Asa Rossoff
Congratulations Ashish and Dilip! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Sunday, July 01, 2012 9:25 AM To: excel-macros Cc: Dilip Pandey; ashish koul Subject: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and

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

2012-07-02 Thread Asa Rossoff
Sorry to hear that. Your work is still valued by many, Don. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Sunday, July 01, 2012 10:04 AM To: excel-macros Cc: Dilip Pandey; ashish koul Subject: Re: $$Excel-Macros$$ MVP

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

2012-07-02 Thread Ojemeni Uzoma
Hello Everyone, Kindly assist with a Macro. Thanks. Uzoma Ojemeni Uzoma | Call 08060700717 -Original Message- From: OJEMENI Uzoma uojem...@gmail.com Date: Sun, 1 Jul 2012 19:02:25 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro to populate Output file Hello

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

2012-07-02 Thread Hari
Congratulations to both of you. Keep smiling, Regards, Harish On 2 July 2012 11:51, Kuldeep Singh naukrikuld...@gmail.com wrote: Congratulations both of you Regards, Kuldeep Singh Back Office Executive Info Edge India Limited (naukri.com) Phone.: +91-120-4763793, Extn.: 793,

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

2012-07-02 Thread Hari
Congratulations to both of you. Keep smiling, Regards, Harish On 2 July 2012 12:19, Hari harisha.prabha...@gmail.com wrote: Congratulations to both of you. Keep smiling, Regards, Harish On 2 July 2012 11:51, Kuldeep Singh naukrikuld...@gmail.com wrote: Congratulations both of

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 noorain.ans...@gmail.comwrote: 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

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

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,

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 waheedb...@gmail.com wrote: =vlookup(I7,$E$7:$F$14,2,1) On Mon, Jul 2, 2012 at 11:32 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Manoj, Please more explain..what is your exact requirement. --

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 jainayus...@gmail.com 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

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 jainayus...@gmail.com wrote: Dear members, I am extremely happy to

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 noorain.ans...@gmail.com 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/

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, सुनिता पौडेल tosune...@gmail.com 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

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 abhishek@gmail.comwrote: Many congratulations to Ashish ji and Dilip ji. Well deserved. On Mon, Jul 2, 2012 at 2:04 PM, सुनिता पौडेल tosune...@gmail.com wrote: Wow

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 setu.i...@gmail.com wrote: hey congratulations to both of you.great win...god bless u both On Mon, Jul 2, 2012 at 2:12 PM, Abhishek Jain abhishek@gmail.com wrote: Many congratulations to Ashish ji and

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 amreshkushw...@gmail.comwrote: Congrats. both of you dear. Regards Amresh On Mon, Jul 2, 2012 at 2:21 PM, setu

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$$ 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 richard.m...@gmail.com 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

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$$ 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 amreshkushw...@gmail.com wrote: Kindly fixed table array range. Regards Amresh On Mon, Jul 2, 2012 at 4:41 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear Sir /

$$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$$ 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, resp...@gmail.com wrote: Its just historical stock market information for the Ghana stock exchange and major mkt indicators. But its the idea

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

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 noorain.ans...@gmail.com wrote: Most Welcome bro.. I am not god, i m a simple Excel Lover like you. -- Thanks regards, Noorain Ansari www.noorainansari.com

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

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

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

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 shri.a...@gmail.comwrote: *Congratulations Ashish and Dilip...!!* -- Thanks Regards, Amol Shrivastava +91 99671 18180 On Mon, Jul 2, 2012 at 4:35 PM, Aindril De aind...@gmail.com wrote: Congratulations Ashish and

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 at

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 koul.ash...@gmail.com rahim done bkoul.ash...@gmail.com Abdul done c koul.ash...@gmail.com 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

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 koul.ash...@gmail.com 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

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 koul.ash...@gmail.com wrote: Thank you all... On Mon, Jul 2, 2012 at 4:39 PM, Amol Shrivastava shri.a...@gmail.comwrote: *Congratulations Ashish and

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 koul.ash...@gmail.com wrote: assuming you have table in sheet1 like name status email sham done a koul.ash...@gmail.com rahim done bkoul.ash...@gmail.com Abdul done c koul.ash...@gmail.com nAME IN

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 samde...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 2 Jul 2012 21:01:24 To: excel-macros@googlegroups.com Reply-To:

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, chhajersand...@gmail.com wrote: ** Congratulation Ashish and Dilip. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- *From: * Sam Mathai Chacko samde...@gmail.com *Sender: *

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 na.har...@gmail.com 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

$$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

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 harshita4d...@gmail.com wrote: Medha Information research Offering In House, Online and Corporate training on Excel VBA Course Highlights Fully handson

$$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 the

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 the

$$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, like

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 vijayajith...@gmail.comwrote: CongratsASHISH

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 jainayus...@gmail.com wrote: Dear members, I am extremely happy to