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
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
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
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
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
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
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
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"
>
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,
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
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.
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 &
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
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
*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
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
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)
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
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
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
>
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
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
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
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
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
*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
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
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
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
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
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,
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
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.
>>
>>
>>
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 !! :)
>>
>>
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
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
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
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
=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
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
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
=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
42 matches
Mail list logo