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

[Hari]

Congratulations to both of you.

Keep smiling,

Regards,
Harish

On 2 July 2012 12:19, Hari  wrote:

> Congratulations to both of you.
>
> Keep smiling,
>
> Regards,
> Harish
>
>
> On 2 July 2012 11:51, Kuldeep Singh  wrote:
>
>>
>> Congratulations both of you
>>
>> Regards,
>> Kuldeep Singh
>> Back Office Executive
>> Info Edge India Limited (naukri.com)
>> Phone.: +91-120-4763793, Extn.: 793, 9716615535.
>> naukrikuld...@gmail.com || www.naukri.com
>> *Please* *Consider the environment. Please don't print this e-mail
>> unless you really need to.*
>>
>>
>> On Mon, Jul 2, 2012 at 11:48 AM, Maries  wrote:
>>
>>> *Congratulations Ashish and Dilip!*
>>>
>>>
>>> On Mon, Jul 2, 2012 at 10:17 AM, Anil Gawli wrote:
>>>
 congrats to both of you .
 Regards,
 Anil G

 On Mon, Jul 2, 2012 at 11:35 AM, Asa Rossoff  wrote:

>  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 AwardCongratulations Ashish
> Koul and Dilip Pandey !!
>
>  ** **
>
> And, Don Guillett was not re selected.
>
>  
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>  
>
> *From:* Ayush Jain  
>
> *Sent:* Sunday, July 01, 2012 11:24 AM
>
> *To:* excel-macros  
>
> *Cc:* Dilip Pandey  ; ashish 
> koul
> 
>
> *Subject:* $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul
> and Dilip Pandey !!
>
>  
>
> 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 Pandey* and
> thanks for their big support to this forum.
>
>  
>
> Keep posting !
>
>
> Best regards,
> Ayush Jain
>
> Group Manager
>
> Microsoft MVP
>
>
>
>  
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
> Advice will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
>>>

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

[Hari]

Congratulations to both of you.

Keep smiling,

Regards,
Harish

On 2 July 2012 11:51, Kuldeep Singh  wrote:

>
> Congratulations both of you
>
> Regards,
> Kuldeep Singh
> Back Office Executive
> Info Edge India Limited (naukri.com)
> Phone.: +91-120-4763793, Extn.: 793, 9716615535.
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
>
> On Mon, Jul 2, 2012 at 11:48 AM, Maries  wrote:
>
>> *Congratulations Ashish and Dilip!*
>>
>>
>> On Mon, Jul 2, 2012 at 10:17 AM, Anil Gawli wrote:
>>
>>> congrats to both of you .
>>> Regards,
>>> Anil G
>>>
>>> On Mon, Jul 2, 2012 at 11:35 AM, Asa Rossoff  wrote:
>>>
  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 AwardCongratulations Ashish
 Koul and Dilip Pandey !!

  ** **

 And, Don Guillett was not re selected.

  

 Don Guillett
 Microsoft Excel Developer
 SalesAid Software
 dguille...@gmail.com

  

 *From:* Ayush Jain  

 *Sent:* Sunday, July 01, 2012 11:24 AM

 *To:* excel-macros  

 *Cc:* Dilip Pandey  ; ashish 
 koul
 

 *Subject:* $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul
 and Dilip Pandey !!

  

 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 Pandey* and
 thanks for their big support to this forum.

  

 Keep posting !


 Best regards,
 Ayush Jain

 Group Manager

 Microsoft MVP



  

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 For

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

[Ojemeni Uzoma]

Hello Everyone,

Kindly assist with a Macro.

Thanks.

Uzoma
Ojemeni Uzoma | Call 08060700717

-Original Message-
From: OJEMENI Uzoma 
Date: Sun, 1 Jul 2012 19:02:25 
To: 
Subject: $$Excel-Macros$$ Macro to populate "Output" file

Hello Everyone,

I would appreciate some assistance in creating a macro to export the
content in the file "input" to the file output. The spacing, tabs and
apostrophe should remain the same way as it is in the "output" file.

Thank you everyone.

Ojemeni Uzoma

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[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 AwardCongratulations Ashish Koul and
Dilip Pandey !!

 

And, Don Guillett was not re selected.

 

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

 

From: Ayush Jain   

Sent: Sunday, July 01, 2012 11:24 AM

To: excel-macros   

Cc: Dilip Pandey   ; ashish koul
  

Subject: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and Dilip
Pandey !!

 

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 Pandey and  thanks for
their big support to this forum.

 

Keep posting !


Best regards,
Ayush Jain

Group Manager

Microsoft MVP



 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[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 Dilip
Pandey !!

 

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 Pandey and  thanks for
their big support to this forum.

 

Keep posting !


Best regards,
Ayush Jain

Group Manager

Microsoft MVP



 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[NOORAIN ANSARI]

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, Manoj Kukreja  wrote:

> Hi,
>
> ** **
>
> I need Vlookup for Last Available Date if the 
>
> 
> This message contains information that may be privileged or confidential
> and is the property of PlanetSoft Holdings Inc. It is intended only for the
> person to whom it is addressed. If you are not the intended recipient, you
> are not authorized to read, print, retain, copy, disseminate, distribute,
> or use this message or any part thereof. If you receive this message in
> error, please notify the sender immediately and delete all copies of this
> message.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com<>

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

[NOORAIN ANSARI]

Dear Sudhir,

Please use it for unique Name in drop down List..

*=IFERROR(INDEX($A$10:$A$43,MATCH(0,COUNTIF($Q$1:Q1,$A$10:$A$43),0)),"")*

for specific record of Party Name


*
=IFERROR(INDEX($C$10:$C$43,SMALL(IF($A$10:$A$43=$I$6,ROW($C$10:$C$43),""),ROW(B1))-9),"")
*
with ctrl+shfit+enter

see attached sheet.

-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

On Mon, Jul 2, 2012 at 10:58 AM, SUDHIR VERMA  wrote:

> Dear All,
>
> Please look at attachment and help me.
>
>
> thanking u
>
> Regards
>
>
> Sudhir
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Copy of HELP(Sudhir).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[Manoj Kukreja]

Hi,

I need Vlookup for Last Available Date if the
[cid:image001.png@01CD5845.027B11A0]


This message contains information that may be privileged or confidential and is 
the property of PlanetSoft Holdings Inc. It is 
intended only for the person to whom it is addressed. If you are not the 
intended recipient, you are not authorized to 
read, print, retain, copy, disseminate, distribute, or use this message or any 
part thereof. If you receive this message 
in error, please notify the sender immediately and delete all copies of this 
message.

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com<>

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

[Manoj Kumar]

Dear Sudhir


Please find the attachment...


Regard
Manoj

On Mon, Jul 2, 2012 at 10:58 AM, SUDHIR VERMA  wrote:

> Dear All,
>
> Please look at attachment and help me.
>
>
> thanking u
>
> Regards
>
>
> Sudhir
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

HELP.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Index Formula Help

[SUDHIR VERMA]

Dear All,

Please look at attachment and help me.


thanking u

Regards


Sudhir

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

HELP.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[Rohan Young]

Congratulations to both of you and thanks for being with us



On Sun, Jul 1, 2012 at 11:32 PM, Dilip Pandey  wrote:
> Thanks Ayush..!!
>
> Thanks to all the members of this group for giving us many chances to
> learn by sharing their queries. ;)
>
> It is a great group.. . Thanks once again.
>
> Regards,
> DILIPandey
>
> On 7/1/12, 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 Pandey* and
>> thanks for their big support to this forum.
>>
>> Keep posting !
>>
>> Best regards,
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>> not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
>MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
> Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not 
> get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to 
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ tricky some question

[danial mansoor]

thanx Noorani got the answer


Date: Sat, 30 Jun 2012 23:18:16 +0530
Subject: Re: $$Excel-Macros$$ tricky some question
From: noorain.ans...@gmail.com
To: excel-macros@googlegroups.com

Dear Danial,

Please use

 =Get.cell(21,indirect("RC[1]",)  and create Name range.

then use simple

=SUMPRODUCT(($A$5:$A$9=FALSE)*(C5:C9))

or

=SUMIF($A$5:$A$9,FALSE,C5:C9)


See attached sheet for more reference.


Please revert if you have any query.

-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com 
On Sat, Jun 30, 2012 at 11:06 PM, danial mansoor  wrote:







Dear noorani,

i have attached a sample sheet hope you get idea from the given sheet,i will 
have to do manual sum as i did in a given sheet and it is hectic job i have 
huge data plz help.



Date: Sat, 30 Jun 2012 22:50:29 +0530
Subject: Re: $$Excel-Macros$$ tricky some question
From: noorain.ans...@gmail.com
To: excel-macros@googlegroups.com


Dear Mansoor

Please share your workbook with group.

It is possible through Get.Cell Function in Excel.

On Sat, Jun 30, 2012 at 3:38 PM, danial mansoor  wrote:







Dear Experts,

i have 2 heads of utilities one is bold and another is in general form and i 
have a bunch of data with same format,wat i want to sum data with one with 
general format UTILITIES,now when ever i apply sumif and sumproduct it include 
both the heads and sum both the figures number.



Is there a way to pick only head which is not bold can i sum using unformated 
head of UTILITIES?  




  UTILITIES



  UTILITIES


Date: Sat, 30 Jun 2012 15:30:45 +0530
Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding raw
From: ashishbhalar...@gmail.com


To: excel-macros@googlegroups.com

We have manufacturer unit and using fox base software, but now we are going to 
develop software of ERP in SQL, so we are transferring data from Fox to excel 
and after processing in excel transfer to SQL software of back financial year. 
But now this my query is more difficult to do, so I need your help because as I 
told there are thousands of record to process and is more difficult to do 
manually. If you have a solution for my query it will be more useful for me.



Actually I tried my level best but in my task I need function formula which 
receive data from another sheet only once time (not repeat), inshort I use 
vlookup but there are repetition of data, what is the function in which data 
not repeat if some type of condition true.



Thanks.


On Sat, Jun 30, 2012 at 10:40 AM, Rajan_Verma  wrote:



homework


 
 



Regards  

Rajan verma
+91 7838100659 [IM-Gtalk]



 
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Ashish Bhalara



Sent: 30 June 2012 9:21
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding raw



 
Dear experts,
 
Please suggest what should I do in that case, waiting for reply.
On Fri, Jun 29, 2012 at 7:23 PM, Ashish Bhalara  
wrote:

 On Fri, Jun 29, 2012 at 7:20 PM, Ashish Bhalara  
wrote:


Dear experts,
 

I need a function or macro to replace data from another sheets by addition of 
raw, these addition of raw is depend on the record of another sheet. you can 
find attached sheet for better understanding. I can do it manually but there 
are thousands of record to process so its not possible to do this. 




 

Thanks & regards.
 
Ashish Bhalara
9624111822

PPlease do not print this email unless it is absolutely necessary. Spread 
environmental üawareness.



 
 
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.



 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.



 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.



 
--
To post to this group, send email to excel-macros@googlegroups.com



 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com



 
-- 
Thanks & regards.

 
Ashish Bhalara
9624111822
PPlease do not print this email unless it is absolutely necessary. Spread 
environmental üawareness.



 
 


 

-- 
Thanks & regards.
 
Ashish Bhalara
9624111822

PPlease do not print this email unless it is absolutely necessary. Spread 
environmental üawareness.



 
 
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread title

RE: $$Excel-Macros$$ tricky some question

[danial mansoor]

can you plz send me attached work book with screen shoots,because when ever i 
open ur attached work book is bold name get disappear from NAME Manager and 
when i apply the formula it gives me False in every row n sum all the rows 
kindly send me  n send me in 2007 format



Date: Sat, 30 Jun 2012 23:38:05 +0530
Subject: Re: $$Excel-Macros$$ tricky some question
From: noorain.ans...@gmail.com
To: excel-macros@googlegroups.com

Dear Danial,

Please see attached workbook, It's working fine in it.

For right reference you use..it
=Get.cell(21,indirect("RC[1]",)

and for Left reference please use

=Get.cell(21,indirect("RC[-1]",)




Hope it will help to you.


On Sat, Jun 30, 2012 at 11:33 PM, danial mansoor  wrote:





noorani when i use name ranges it gives me False at every row and eventually 
answers gets wrong,when ever i open ur work book it gives me NAME error could 
you plz send me your solve work book with correct answers?




Date: Sat, 30 Jun 2012 23:18:16 +0530
Subject: Re: $$Excel-Macros$$ tricky some question
From: noorain.ans...@gmail.com

To: excel-macros@googlegroups.com

Dear Danial,

Please use

 =Get.cell(21,indirect("RC[1]",)  and create Name range.

then use simple


=SUMPRODUCT(($A$5:$A$9=FALSE)*(C5:C9))

or

=SUMIF($A$5:$A$9,FALSE,C5:C9)


See attached sheet for more reference.


Please revert if you have any query.

-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com

www.excelmacroworld.blogspot.com 
On Sat, Jun 30, 2012 at 11:06 PM, danial mansoor  wrote:








Dear noorani,

i have attached a sample sheet hope you get idea from the given sheet,i will 
have to do manual sum as i did in a given sheet and it is hectic job i have 
huge data plz help.




Date: Sat, 30 Jun 2012 22:50:29 +0530
Subject: Re: $$Excel-Macros$$ tricky some question
From: noorain.ans...@gmail.com
To: excel-macros@googlegroups.com



Dear Mansoor

Please share your workbook with group.

It is possible through Get.Cell Function in Excel.

On Sat, Jun 30, 2012 at 3:38 PM, danial mansoor  wrote:








Dear Experts,

i have 2 heads of utilities one is bold and another is in general form and i 
have a bunch of data with same format,wat i want to sum data with one with 
general format UTILITIES,now when ever i apply sumif and sumproduct it include 
both the heads and sum both the figures number.




Is there a way to pick only head which is not bold can i sum using unformated 
head of UTILITIES?  





  UTILITIES




  UTILITIES


Date: Sat, 30 Jun 2012 15:30:45 +0530
Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding raw
From: ashishbhalar...@gmail.com



To: excel-macros@googlegroups.com

We have manufacturer unit and using fox base software, but now we are going to 
develop software of ERP in SQL, so we are transferring data from Fox to excel 
and after processing in excel transfer to SQL software of back financial year. 
But now this my query is more difficult to do, so I need your help because as I 
told there are thousands of record to process and is more difficult to do 
manually. If you have a solution for my query it will be more useful for me.




Actually I tried my level best but in my task I need function formula which 
receive data from another sheet only once time (not repeat), inshort I use 
vlookup but there are repetition of data, what is the function in which data 
not repeat if some type of condition true.




Thanks.


On Sat, Jun 30, 2012 at 10:40 AM, Rajan_Verma  wrote:




homework


 
 




Regards  

Rajan verma
+91 7838100659 [IM-Gtalk]




 
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Ashish Bhalara




Sent: 30 June 2012 9:21
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding raw




 
Dear experts,
 
Please suggest what should I do in that case, waiting for reply.
On Fri, Jun 29, 2012 at 7:23 PM, Ashish Bhalara  
wrote:

 On Fri, Jun 29, 2012 at 7:20 PM, Ashish Bhalara  
wrote:


Dear experts,
 

I need a function or macro to replace data from another sheets by addition of 
raw, these addition of raw is depend on the record of another sheet. you can 
find attached sheet for better understanding. I can do it manually but there 
are thousands of record to process so its not possible to do this. 





 

Thanks & regards.
 
Ashish Bhalara
9624111822

PPlease do not print this email unless it is absolutely necessary. Spread 
environmental üawareness.




 
 
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.




 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.




 

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

[OJEMENI Uzoma]

Hello Everyone,

I would appreciate some assistance in creating a macro to export the
content in the file "input" to the file output. The spacing, tabs and
apostrophe should remain the same way as it is in the "output" file.

Thank you everyone.

Ojemeni Uzoma

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com"Cell"  "NCELL1""NCELL2""NCELL3""NCELL4"
"NCELL5""NCELL6""NCELL7""NCELL8""NCELL9"
"NCELL10"
"201022""201021 201023 200013 200661 200662 200192" ""  ""  
""  ""  ""  ""  ""  ""  ""
"201023""200563 200243 200753 201043 201021 201022 200661 200663 200193 
200391 200392 200393 200561"""  ""  ""  ""  ""  ""  
""  ""  ""


input.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

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

[Dilip Pandey]

Thanks Ayush..!!

Thanks to all the members of this group for giving us many chances to
learn by sharing their queries. ;)

It is a great group.. . Thanks once again.

Regards,
DILIPandey

On 7/1/12, 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 Pandey* and
> thanks for their big support to this forum.
>
> Keep posting !
>
> Best regards,
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[in . vaibhav]

Yes Don ayush is correct I use your ideas to solve many problems at many other 
forum n sites. 

This is great forum for newbies n expert. 

You all are stars n made this forum unique.

Thanks to all.

-Original Message-
From: Ayush Jain 
Sender: excel-macros@googlegroups.com
Date: Sun, 1 Jul 2012 22:52:44 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and
 Dilip Pandey !!

Don,

You are valuable to this forum and a star performer.
We really admire you and appreciate your great contribution to this forum.

Regards
Ayush Jain

On Sun, Jul 1, 2012 at 10:34 PM, dguillett1  wrote:

>   And, Don Guillett was not re selected.
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Ayush Jain 
> *Sent:* Sunday, July 01, 2012 11:24 AM
>  *To:* excel-macros 
> *Cc:* Dilip Pandey  ; ashish koul
> *Subject:* $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and
> Dilip Pandey !!
>
>   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 Pandey* and
> thanks for their big support to this forum.
>
> Keep posting !
>
> Best regards,
> Ayush Jain
> Group Manager
> Microsoft MVP
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
Best regards,
Ayush Jain

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

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

[NOORAIN ANSARI]

 Download Excel-VBA
Ebook
 Download EXCEL-VBA Ebook..

http://search.4shared.com/q/CCAD/1/excel+vba
http://pdftop.net/excel+vba+tutorial-pdf/

On Sun, Jul 1, 2012 at 10:32 PM, Venkatesh Narla wrote:

> Hi All,
> Please help me to fine the VBA PDF books link need.
>
>
> Thanks,
> Venkatesh.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[NOORAIN ANSARI]

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.edu.sg/~justin88/Excel%202007%20Power%20Programming%20With%20VBA.
pdf

On Sun, Jul 1, 2012 at 10:32 PM, Venkatesh Narla wrote:

> Hi All,
> Please help me to fine the VBA PDF books link need.
>
>
> Thanks,
> Venkatesh.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[Ayush Jain]

Don,

You are valuable to this forum and a star performer.
We really admire you and appreciate your great contribution to this forum.

Regards
Ayush Jain

On Sun, Jul 1, 2012 at 10:34 PM, dguillett1  wrote:

>   And, Don Guillett was not re selected.
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Ayush Jain 
> *Sent:* Sunday, July 01, 2012 11:24 AM
>  *To:* excel-macros 
> *Cc:* Dilip Pandey  ; ashish koul
> *Subject:* $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and
> Dilip Pandey !!
>
>   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 Pandey* and
> thanks for their big support to this forum.
>
> Keep posting !
>
> Best regards,
> Ayush Jain
> Group Manager
> Microsoft MVP
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
Best regards,
Ayush Jain

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[dguillett1]

And, Don Guillett was not re selected.

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: Ayush Jain 
Sent: Sunday, July 01, 2012 11:24 AM
To: excel-macros 
Cc: Dilip Pandey ; ashish koul 
Subject: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and Dilip 
Pandey !!

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 Pandey and  thanks for 
their big support to this forum.

Keep posting !

Best regards,
Ayush Jain
Group Manager
Microsoft MVP


 
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[Venkatesh Narla]

Hi All,
Please help me to fine the VBA PDF books link need.


Thanks,
Venkatesh.

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[NOORAIN ANSARI]

Many Many My heartiest congratulations to Both of You.


-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

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 Pandey* and
> thanks for their big support to this forum.
>
> Keep posting !
>
> Best regards,
> Ayush Jain
> Group Manager
> Microsoft MVP
>
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[ashwani agnihotri]

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 10:02 PM, Rajan_Verma wrote:

> What do you want to send in mail??b 
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *ashwani agnihotri
> *Sent:* 01 July 2012 9:49
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Query on Email via macro
>
> ** **
>
> Hi,
>
> ** **
>
> I have a query..suppose i put some thing in column B and i have mail id in
> column C i want to send the mail on that ID.
>
> ** **
>
> In the example given below if i enter done in column B a mail should be
> send on address entered in column C
>
> ** **
>
>ABC
>
> ram
>
>  
>
>  
>
>  
>
> sham
>
> done
>
> *sham@xyzmail*
>
>  
>
> rahim
>
> done
>
> *rahim@xyzmail*
>
>  
>
> Abdul
>
>  
>
>  
>
>  
>
>  
>
> ** **
>
> Can someone help me with this??
>
> ** **
>
> Regards
>
> ** **
>
> Ashwani
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[Lalit Mohan]

Congaratulation Ashish and Dilip

 

 

Regards,

Lalit Mohan

www.excelfox.com/forum

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajan_Verma
Sent: Sunday, July 01, 2012 9:56 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and
Dilip Pandey !!

 

Congrats both of you ..  J

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush Jain
Sent: 01 July 2012 9:55
To: excel-macros
Cc: Dilip Pandey; ashish koul
Subject: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and Dilip
Pandey !!

 

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 Pandey and  thanks for
their big support to this forum.

 

Keep posting !


Best regards,
Ayush Jain

Group Manager

Microsoft MVP



 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[Rajan_Verma]

What do you want to send in mail??

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashwani agnihotri
Sent: 01 July 2012 9:49
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query on Email via macro

 

Hi,

 

I have a query..suppose i put some thing in column B and i have mail id in
column C i want to send the mail on that ID.

 

In the example given below if i enter done in column B a mail should be send
on address entered in column C

 

   ABC


ram

 

 

 


sham

done

sham@xyzmail

 


rahim

done

rahim@xyzmail

 


Abdul

 

 

 

 

 

Can someone help me with this??

 

Regards

 

Ashwani

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[Rajan_Verma]

Congrats both of you ..  J

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush Jain
Sent: 01 July 2012 9:55
To: excel-macros
Cc: Dilip Pandey; ashish koul
Subject: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and Dilip
Pandey !!

 

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 Pandey and  thanks for
their big support to this forum.

 

Keep posting !


Best regards,
Ayush Jain

Group Manager

Microsoft MVP



 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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

[ashwani agnihotri]

Hi,

I have a query..suppose i put some thing in column B and i have mail id in
column C i want to send the mail on that ID.

In the example given below if i enter done in column B a mail should be
send on address entered in column C

   ABC

ram







sham

done

*sham@xyzmail*



rahim

done

*rahim@xyzmail*



Abdul








Can someone help me with this??

Regards

Ashwani

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: FW: $$Excel-Macros$$ Macro timings should be multiple based on date changing

[Lokesh Loki]

Hi Lalit,

Thank you so much for your help.

I wish you have a great future ahead. Once again thanks for all to helping
me.

Regards
Lokesh.M

On Sun, Jul 1, 2012 at 8:38 PM, Lalit Mohan wrote:

> Hi Lokesh,
>
> ** **
>
> We are always happy to help you.
>
> ** **
>
> *Regards,*
>
> *Lalit Mohan*
>
> *www.excelfox.com/forum*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki
> *Sent:* Saturday, June 30, 2012 8:36 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: FW: $$Excel-Macros$$ Macro timings should be multiple
> based on date changing
>
> ** **
>
> Hi Brother,
>
> The below formula is working thanks a lot.
>
> Have a nice day.
>
> Regards
> Lokesh.M
>
> On Sat, Jun 30, 2012 at 8:32 PM, Rajan_Verma 
> wrote:
>
>  
>
> Use this:
>
>  
>
> =IF(NOT(ISBLANK(D12)),D12+(((A13-A12)+1)/24*4),"")
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki
> *Sent:* 30 June 2012 8:30
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: FW: $$Excel-Macros$$ Macro timings should be multiple
> based on date changing
>
>  
>
> yes thank you, now the i have changed the date format.
>
> And one more correction if there is no user timings and macro timings the
> result should be shown blank not for 4:00:00.
>
> please do the needful brother.
>
> Regards
> Lokesh.M
>
> On Sat, Jun 30, 2012 at 8:26 PM, Rajan_Verma 
> wrote:
>
> Hi Lokesh
>
>  
>
> *You must apply [h]:mm:ss format on that cell to get proper result*
>
>  
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* Rajan_Verma [mailto:rajanverma1...@gmail.com]
> *Sent:* 30 June 2012 10:38
> *To:* 'excel-macros@googlegroups.com'
> *Subject:* RE: $$Excel-Macros$$ Macro timings should be multiple based on
> date changing
>
>  
>
> Use this One in G11:
>
>  
>
> =D11+(((A12-A11)+1)/24*4) 
>
>  
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>
> *From:* excel-macros@googlegroups.com
> [mailto:excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki
>
>
> *Sent:* 30 June 2012 7:31
> *To:* excel-macros@googlegroups.com
>
> *Subject:* Re: $$Excel-Macros$$ Macro timings should be multiple based on
> date changing
>
>  
>
> Hi Lalit,
>
> Thanks for replying to my query.
>
> Actually i needed when i am changing the dates the macro timings i.e.
> 4:00:00 should be multiplied like this 8:00:00, 12:00:00, 16:00:00 and this
> timings will added to the total timings.
>
> Examples:
>
>   * TimingsMacro timings   Total timings*
>  5:30:15 +  4:00:00   =   9:30:15
>  5:30:15 +  8:00:00   =  13:30:15
>  5:30:15 + 12:00:00  =  17:30:15
>  5:30:15 + 12:00:00  =  21:30:15
>
> Please refer attached excel sheet i have mentioned date wise results so do
> the needful.
>
> Regards
> Lokesh.M
>
> On Fri, Jun 29, 2012 at 8:01 PM, Lalit Mohan 
> wrote:
>
> Hi Lokesh,
>
>  
>
> Please find the attached. Change the formula accordingly.
>
>  
>
>  
>
> *Regards,*
>
> *Lalit Mohan*
>
> *www.excelfox.com/forum*
>
>  
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki
> *Sent:* Friday, June 29, 2012 7:18 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Macro timings should be multiple based on
> date changing
>
>  
>
> Hi All,
>
> Please find the attached excel file, and i need total macro timings based
> on date changes.
>
> Let me know for any clarification.
>
> Regards
> Lokesh.M
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) 

RE: FW: $$Excel-Macros$$ Macro timings should be multiple based on date changing

[Lalit Mohan]

Hi Lokesh,

 

We are always happy to help you.

 

Regards,

Lalit Mohan

www.excelfox.com/forum

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: Saturday, June 30, 2012 8:36 PM
To: excel-macros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ Macro timings should be multiple based on
date changing

 

Hi Brother,

The below formula is working thanks a lot.

Have a nice day. 

Regards
Lokesh.M

On Sat, Jun 30, 2012 at 8:32 PM, Rajan_Verma 
wrote:

 

Use this:

 

=IF(NOT(ISBLANK(D12)),D12+(((A13-A12)+1)/24*4),"")

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: 30 June 2012 8:30
To: excel-macros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ Macro timings should be multiple based on
date changing

 

yes thank you, now the i have changed the date format.

And one more correction if there is no user timings and macro timings the
result should be shown blank not for 4:00:00.

please do the needful brother.

Regards
Lokesh.M

On Sat, Jun 30, 2012 at 8:26 PM, Rajan_Verma 
wrote:

Hi Lokesh

 

You must apply [h]:mm:ss format on that cell to get proper result

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: Rajan_Verma [mailto:rajanverma1...@gmail.com] 
Sent: 30 June 2012 10:38
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Macro timings should be multiple based on date
changing

 

Use this One in G11:

 

=D11+(((A12-A11)+1)/24*4) 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki


Sent: 30 June 2012 7:31
To: excel-macros@googlegroups.com

Subject: Re: $$Excel-Macros$$ Macro timings should be multiple based on date
changing

 

Hi Lalit,

Thanks for replying to my query.

Actually i needed when i am changing the dates the macro timings i.e.
4:00:00 should be multiplied like this 8:00:00, 12:00:00, 16:00:00 and this
timings will added to the total timings.

Examples:

   TimingsMacro timings   Total timings
 5:30:15 +  4:00:00   =   9:30:15 
 5:30:15 +  8:00:00   =  13:30:15
 5:30:15 + 12:00:00  =  17:30:15
 5:30:15 + 12:00:00  =  21:30:15

Please refer attached excel sheet i have mentioned date wise results so do
the needful.

Regards
Lokesh.M

On Fri, Jun 29, 2012 at 8:01 PM, Lalit Mohan 
wrote:

Hi Lokesh,

 

Please find the attached. Change the formula accordingly.

 

 

Regards,

Lalit Mohan

www.excelfox.com/forum

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: Friday, June 29, 2012 7:18 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro timings should be multiple based on date
changing

 

Hi All,

Please find the attached excel file, and i need total macro timings based on
date changes. 

Let me know for any clarification.

Regards
Lokesh.M

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ Re: Book3.xlsx

[Lalit Mohan]

Hi Neeraj,

 

Try this:

 

Sub FindFormula()

Dim rngDtRange  As Range

Const strDataRange  As String = "B1:B1000"

With ThisWorkbook.Worksheets("Sheet1").Range(strDataRange)

For Each rngDtRange In .Range(strDataRange)

If rngDtRange.Formula like "=RandBetween*" Then

rngDtRange.Offset(, 1).Formula = rngDtRange.Formula

End If

Next rngDtRange

End With

End Sub

 

 

Regards,

Lalit Mohan

www.excelfox.com/forum

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prince Dubey
Sent: Saturday, June 30, 2012 6:23 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Book3.xlsx

 

Hi Neeraj,

 

Try Out This,

 

Sub test()

Dim rng As Range

Dim intCountAs Integer

 

Application.ScreenUpdating = False

With ThisWorkbook.Worksheets("Sheet1")



Set rng = .Range("A1").CurrentRegion

For intCount = 2 To rng.Rows.Count

If InStr(1, rng.Cells(intCount, 2).Formula, "RandBetween",
vbTextCompare) <> 0 Then

rng.Cells(intCount, 2).Copy

rng.Cells(intCount, 3).PasteSpecial (xlPasteAll)

Application.CutCopyMode = False

End If

Next



End With

Application.ScreenUpdating = True

End Sub

 

 

Regards

Prince Dubey.

 



On Friday, 29 June 2012 12:11:51 UTC+5:30, neeraj chauhan wrote:

Dear Experts,

 

I have a sheet kindly find it,  if we have two formulas in one  "B" Colum
and I want to paste special only one (Randbetween) formula then how can I do
it? 

 

Kindly find the attached sheet for the concerned.

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ tricky some question

[dguillett1]

Put in a macro enabled workbook

Sub sumifNOTbold()
dim I as long
dim ii as long

For i = 3 To 7
ms = 0
For ii = 5 To 9
  If Cells(ii, 2).Font.Bold =False Then ms = ms + Cells(ii, i)
Next ii
MsgBox ms
Cells(16, i) = ms
Next i
end sub


Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: NOORAIN ANSARI 
Sent: Saturday, June 30, 2012 12:48 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ tricky some question

Dear Danial,

Please use

=Get.cell(21,indirect("RC[1]",)  and create Name range.

then use simple

=SUMPRODUCT(($A$5:$A$9=FALSE)*(C5:C9))

or

=SUMIF($A$5:$A$9,FALSE,C5:C9)

See attached sheet for more reference.


Please revert if you have any query.

-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com 
www.excelmacroworld.blogspot.com
 

On Sat, Jun 30, 2012 at 11:06 PM, danial mansoor  wrote:




  Dear noorani,

  i have attached a sample sheet hope you get idea from the given sheet,i will 
have to do manual sum as i did in a given sheet and it is hectic job i have 
huge data plz help.




--
  Date: Sat, 30 Jun 2012 22:50:29 +0530
  Subject: Re: $$Excel-Macros$$ tricky some question
  From: noorain.ans...@gmail.com
  To: excel-macros@googlegroups.com 


  Dear Mansoor

  Please share your workbook with group.

  It is possible through Get.Cell Function in Excel.


  On Sat, Jun 30, 2012 at 3:38 PM, danial mansoor  
wrote:


Dear Experts,

i have 2 heads of utilities one is bold and another is in general form and 
i have a bunch of data with same format,wat i want to sum data with one with 
general format UTILITIES,now when ever i apply sumif and sumproduct it include 
both the heads and sum both the figures number.

Is there a way to pick only head which is not bold can i sum using 
unformated head of UTILITIES?  

  UTILITIES 
  UTILITIES 






Date: Sat, 30 Jun 2012 15:30:45 +0530
Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding raw
From: ashishbhalar...@gmail.com
To: excel-macros@googlegroups.com

We have manufacturer unit and using fox base software, but now we are going 
to develop software of ERP in SQL, so we are transferring data from Fox to 
excel and after processing in excel transfer to SQL software of back financial 
year. But now this my query is more difficult to do, so I need your help 
because as I told there are thousands of record to process and is more 
difficult to do manually. If you have a solution for my query it will be more 
useful for me. 

Actually I tried my level best but in my task I need function formula which 
receive data from another sheet only once time (not repeat), inshort I use 
vlookup but there are repetition of data, what is the function in which data 
not repeat if some type of condition true.

Thanks.




On Sat, Jun 30, 2012 at 10:40 AM, Rajan_Verma  
wrote:

  homework
   
   
  Regards  
  Rajan verma
  +91 7838100659 [IM-Gtalk]
   
  From: excel-macros@googlegroups.com 
[mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara
  Sent: 30 June 2012 9:21
  To: excel-macros@googlegroups.com
  Subject: Re: $$Excel-Macros$$ Replace data from another sheets by adding 
raw


  Dear experts,


   
  Please suggest what should I do in that case, waiting for reply.

  On Fri, Jun 29, 2012 at 7:23 PM, Ashish Bhalara 
 wrote:



  On Fri, Jun 29, 2012 at 7:20 PM, Ashish Bhalara 
 wrote:

Dear experts,


 
I need a function or macro to replace data from another sheets by 
addition of raw, these addition of raw is depend on the record of another 
sheet. you can find attached sheet for better understanding. I can do it 
manually but there are thousands of record to process so its not possible to do 
this. 


 
Thanks & regards.


 
Ashish Bhalara

9624111822

PPlease do not print this email unless it is absolutely necessary. 
Spread environmental üawareness.


 
 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security 
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential dat

Re: $$Excel-Macros$$ Automatic Email from Excel

[David Grugeon]

See forum rule 2

On 1 July 2012 17:58, ashwani agnihotri  wrote:

> *guys does anyone has any opinion on this problem???
> *
>
> On Fri, Jun 29, 2012 at 9:19 PM, ashwani agnihotri <
> ashwani.agniho...@gmail.com> wrote:
>
>> Hi,
>>
>> I have a query..suppose i put some thing in column B and i have mail id
>> in column C i want to sent the mail on that ID.
>>
>> In the example given below if i enter done in column B a mail should be
>> send on address entered in column C
>>
>>ABC
>>
>> ram
>>
>>
>>
>>
>>
>>
>>
>> sham
>>
>> done
>>
>> *sham@xyzmail*
>>
>>
>>
>> rahim
>>
>> done
>>
>> *rahim@xyzmail*
>>
>>
>>
>> Abdul
>>
>>
>>
>>
>>
>>
>>
>>
>> Can someone help me with this??
>>
>>
>> On Thu, Jun 28, 2012 at 4:05 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Hemanath,
>>>
>>> Please try it..
>>>
>>> Sub maildata()
>>> Dim olApp As Outlook.Application
>>> Dim olMail As MailItem
>>> Dim i As Integer, j As Integer
>>> Dim sh As Worksheet
>>> On Error Resume Next
>>> Application.ScreenUpdating = False
>>> Set olApp = New Outlook.Application
>>> Set olMail = olApp.CreateItem(olMailItem)
>>> Set sh = ThisWorkbook.Sheets(1)
>>> With sh
>>>   j = sh.Range("B" & Rows.Count).End(xlUp).Row
>>>   For i = 2 To j
>>>   If CDate(.Cells(i, "B")) = Date Then
>>>  With olMail
>>> .To = .Cells(i, "D")
>>> .CC = "noorain.ans...@gmail.com"
>>> .Subject = .Cells(i, "C")
>>> .Body = "Hi" & vbCrLf & vbCrLf & "Please find the
>>> attached Report" & " Thanks " & vbCrLf & vbCrLf & vbCrLf & "Regards" &
>>> vbCrLf & " Noorain Ansari"
>>> .Display
>>>  End With
>>>   End If
>>>   Next i
>>> End With
>>>   Set olMail = Nothing
>>>   Application.ScreenUpdating = True
>>>   On Error GoTo 0
>>> End Sub
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.excelmacroworld.blogspot.com
>>>
>>> On Thu, Jun 28, 2012 at 2:29 PM, hemanath dhanasekar <
>>> hema5s...@gmail.com> wrote:
>>>
 Friends,

 I have an excel spreadsheet with dates updated on it, all I need is
 that the system should automatically send an Email to the specified email
 address automatically by picking up that particular date.

 Ex:

 Date:Subject  To

 29/06/2012 Renew your Insurancehema5s...@gmail.com

 so, on 28th or 29th the system should automatically send an email and
 to that particular person with that subject from spreadsheet.

 is that Possible? if yes means please help me.

 --
 Thanks
 Hemanath.D

  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Ne

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

[Haris]

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"
With Regards,
Haris
na.har...@gmail.com



On 1 July 2012 11:13, Haris  wrote:

> Thank you so much* Mr. Ashish koul.* This is what i exactly looking for.
> I appreciate your generous support.
> With Regards,
> Haris
> na.har...@gmail.com
>
>
>
> On 1 July 2012 09:53, ashish koul  wrote:
>
>> =INDEX($C$1:$F$1,MATCH(SMALL(C2:F2,COUNTIF(C2:F2,0)+1),C2:F2,0))
>>
>>
>> On Sun, Jul 1, 2012 at 11:13 AM, Haris  wrote:
>>
>>> Dear friends,
>>>
>>>  I want to choose the best (minimum) rate offered from 4 companies.if
>>> some companies not having that product i will put zero in their rate
>>> column. so this zero make me confused while taking min rate. so kindly
>>> check this attached file and do let me know the solution.
>>> With Regards,
>>> Haris
>>> na.har...@gmail.com
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *http://www.excelvbamacros.com/*
>> *http://www.accessvbamacros.com/* 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Automatic Email from Excel

[ashwani agnihotri]

*guys does anyone has any opinion on this problem???
*
On Fri, Jun 29, 2012 at 9:19 PM, ashwani agnihotri <
ashwani.agniho...@gmail.com> wrote:

> Hi,
>
> I have a query..suppose i put some thing in column B and i have mail id in
> column C i want to sent the mail on that ID.
>
> In the example given below if i enter done in column B a mail should be
> send on address entered in column C
>
>ABC
>
> ram
>
>
>
>
>
>
>
> sham
>
> done
>
> *sham@xyzmail*
>
>
>
> rahim
>
> done
>
> *rahim@xyzmail*
>
>
>
> Abdul
>
>
>
>
>
>
>
>
> Can someone help me with this??
>
>
> On Thu, Jun 28, 2012 at 4:05 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Hemanath,
>>
>> Please try it..
>>
>> Sub maildata()
>> Dim olApp As Outlook.Application
>> Dim olMail As MailItem
>> Dim i As Integer, j As Integer
>> Dim sh As Worksheet
>> On Error Resume Next
>> Application.ScreenUpdating = False
>> Set olApp = New Outlook.Application
>> Set olMail = olApp.CreateItem(olMailItem)
>> Set sh = ThisWorkbook.Sheets(1)
>> With sh
>>   j = sh.Range("B" & Rows.Count).End(xlUp).Row
>>   For i = 2 To j
>>   If CDate(.Cells(i, "B")) = Date Then
>>  With olMail
>> .To = .Cells(i, "D")
>> .CC = "noorain.ans...@gmail.com"
>> .Subject = .Cells(i, "C")
>> .Body = "Hi" & vbCrLf & vbCrLf & "Please find the
>> attached Report" & " Thanks " & vbCrLf & vbCrLf & vbCrLf & "Regards" &
>> vbCrLf & " Noorain Ansari"
>> .Display
>>  End With
>>   End If
>>   Next i
>> End With
>>   Set olMail = Nothing
>>   Application.ScreenUpdating = True
>>   On Error GoTo 0
>> End Sub
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.com
>>
>> On Thu, Jun 28, 2012 at 2:29 PM, hemanath dhanasekar > > wrote:
>>
>>> Friends,
>>>
>>> I have an excel spreadsheet with dates updated on it, all I need is that
>>> the system should automatically send an Email to the specified email
>>> address automatically by picking up that particular date.
>>>
>>> Ex:
>>>
>>> Date:Subject  To
>>>
>>> 29/06/2012 Renew your Insurancehema5s...@gmail.com
>>>
>>> so, on 28th or 29th the system should automatically send an email and to
>>> that particular person with that subject from spreadsheet.
>>>
>>> is that Possible? if yes means please help me.
>>>
>>> --
>>> Thanks
>>> Hemanath.D
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>>
>>
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you r

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

[Haris]

Thank you so much* Mr. Ashish koul.* This is what i exactly looking for. I
appreciate your generous support.
With Regards,
Haris
na.har...@gmail.com



On 1 July 2012 09:53, ashish koul  wrote:

> =INDEX($C$1:$F$1,MATCH(SMALL(C2:F2,COUNTIF(C2:F2,0)+1),C2:F2,0))
>
>
> On Sun, Jul 1, 2012 at 11:13 AM, Haris  wrote:
>
>> Dear friends,
>>
>>  I want to choose the best (minimum) rate offered from 4 companies.if
>> some companies not having that product i will put zero in their rate
>> column. so this zero make me confused while taking min rate. so kindly
>> check this attached file and do let me know the solution.
>> With Regards,
>> Haris
>> na.har...@gmail.com
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/* 
>
>
> P Before printing, think about the environment.
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com