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

[vijayajith VA]

Congratulations Noorain bayya!!

On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain  wrote:

> Dear members,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> July'12. He has posted 143 posts in July 2012 and helped many forum members
> through his excel expertise.
>
> I truly appreciate his consistency and commitment to the group. He is
> really doing great job.
>
> Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince,
> Sunita and other folks for helping excel enthusiasts voluntarily !!
> Keep posting.
>
> 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$$ Noorain Ansari - Most Helpful Member July 2012

[Sanjib Chatterjee]

Dear Noorain Ansari

Congratulation for your achievement.  As I stated early that you are the
God of Excel.  Please keep it going so that many excel lovers are get help.

Thanking you

Regards,

Sanjib Chatterjee


On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain  wrote:

> Dear members,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> July'12. He has posted 143 posts in July 2012 and helped many forum members
> through his excel expertise.
>
> I truly appreciate his consistency and commitment to the group. He is
> really doing great job.
>
> Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince,
> Sunita and other folks for helping excel enthusiasts voluntarily !!
> Keep posting.
>
> 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$$ Noorain Ansari - Most Helpful Member July 2012

[Deba Ranjan]

My Heartiest Noorain Bro, congrts many more. Really heart of this members.



Thanks & Regards,
*Deba Ranjan P*





On Sat, Aug 4, 2012 at 10:44 AM, अनिल नारायण गवली
wrote:

> congrats noorian ansari:)
> Regards,
> Gawli Anil
>
> On Sat, Aug 4, 2012 at 10:38 AM, Kuldeep Singh wrote:
>
>>
>> Congratulations Noorain Sir.
>>
>> Regards,
>> Kuldeep Singh
>> Back Office Executive (MIS)
>> Info Edge India Limited (naukri.com)
>> Phone.: +91-120-4763789, Extn.: 789,9716615535
>> naukrikuld...@gmail.com || www.naukri.com || www.naukrigulf.com
>> *Please* *Consider the environment. Please don't print this e-mail
>> unless you really need to.*
>>
>>
>> On Sat, Aug 4, 2012 at 10:35 AM, Rajan_Verma wrote:
>>
>>>  *Congrats noorain. *
>>>
>>> * *
>>>
>>> * *
>>>
>>> *Regards*
>>>
>>> *Rajan verma*
>>>
>>> *+91 7838100659 [IM-Gtalk]*
>>>
>>> * *
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain
>>> *Sent:* 03 August 2012 11:10
>>>
>>> *To:* excel-macros
>>> *Subject:* $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July
>>> 2012
>>>
>>> ** **
>>>
>>> Dear members,
>>>
>>>
>>> Noorain Ansari has been selected as 'Most Helpful Member' for the month
>>> of July'12. He has posted 143 posts in July 2012 and helped many forum
>>> members through his excel expertise.
>>>
>>> I truly appreciate his consistency and commitment to the group. He is
>>> really doing great job.
>>>
>>> Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince,
>>> Sunita and other folks for helping excel enthusiasts voluntarily !!
>>> Keep posting.
>>>
>>> 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
>>
>>
>>
>
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1

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

[अनिल नारायण गवली]

congrats noorian ansari:)
Regards,
Gawli Anil

On Sat, Aug 4, 2012 at 10:38 AM, Kuldeep Singh wrote:

>
> Congratulations Noorain Sir.
>
> Regards,
> Kuldeep Singh
> Back Office Executive (MIS)
> Info Edge India Limited (naukri.com)
> Phone.: +91-120-4763789, Extn.: 789,9716615535
> naukrikuld...@gmail.com || www.naukri.com || www.naukrigulf.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
>
> On Sat, Aug 4, 2012 at 10:35 AM, Rajan_Verma wrote:
>
>>  *Congrats noorain. *
>>
>> * *
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> * *
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain
>> *Sent:* 03 August 2012 11:10
>>
>> *To:* excel-macros
>> *Subject:* $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July
>> 2012
>>
>> ** **
>>
>> Dear members,
>>
>>
>> Noorain Ansari has been selected as 'Most Helpful Member' for the month
>> of July'12. He has posted 143 posts in July 2012 and helped many forum
>> members through his excel expertise.
>>
>> I truly appreciate his consistency and commitment to the group. He is
>> really doing great job.
>>
>> Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince,
>> Sunita and other folks for helping excel enthusiasts voluntarily !!
>> Keep posting.
>>
>> 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
>
>
>



-- 
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd

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

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

[Kuldeep Singh]

Congratulations Noorain Sir.

Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge India Limited (naukri.com)
Phone.: +91-120-4763789, Extn.: 789,9716615535
naukrikuld...@gmail.com || www.naukri.com || www.naukrigulf.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Sat, Aug 4, 2012 at 10:35 AM, Rajan_Verma wrote:

> *Congrats noorain. *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain
> *Sent:* 03 August 2012 11:10
>
> *To:* excel-macros
> *Subject:* $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012
> 
>
> ** **
>
> Dear members,
>
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> July'12. He has posted 143 posts in July 2012 and helped many forum members
> through his excel expertise.
>
> I truly appreciate his consistency and commitment to the group. He is
> really doing great job.
>
> Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince,
> Sunita and other folks for helping excel enthusiasts voluntarily !!
> Keep posting.
>
> 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$$ Noorain Ansari - Most Helpful Member July 2012

[Rajan_Verma]

Congrats noorain. 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush Jain
Sent: 03 August 2012 11:10
To: excel-macros
Subject: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

 

Dear members,

 
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
July'12. He has posted 143 posts in July 2012 and helped many forum members
through his excel expertise.
 
I truly appreciate his consistency and commitment to the group. He is really
doing great job.
 
Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince, Sunita
and other folks for helping excel enthusiasts voluntarily !! 
Keep posting.
 
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$$ Noorain Ansari - Most Helpful Member July 2012

[Govind Mori]

Congrats Noorain. As always, your contributions help many.


Govind Mori

-- 
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$$ Noorain Ansari - Most Helpful Member July 2012

[Manoj Kumar]

*Cong Noorain! Ji*

On Sat, Aug 4, 2012 at 4:16 AM, dguillett1  wrote:

>   Good work!
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Ayush Jain 
> *Sent:* Friday, August 03, 2012 12:40 PM
> *To:* excel-macros 
> *Subject:* $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012
>
>  Dear members,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> July'12. He has posted 143 posts in July 2012 and helped many forum members
> through his excel expertise.
>
> I truly appreciate his consistency and commitment to the group. He is
> really doing great job.
>
> Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince,
> Sunita and other folks for helping excel enthusiasts voluntarily !!
> Keep posting.
>
> 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

$$Excel-Macros$$ AUTO: Sharon Hutchison is out of the office (returning 20/08/2012)

[Sharon Hutchison]

I am out of the office until 20/08/2012.

Any queries please contact x54455


Note: This is an automated response to your message  "$$Excel-Macros$$
Digest for excel-macros@googlegroups.com - 20 Messages in 11 Topics" sent
on 4/8/2012 1:10:52 AM.

This is the only notification you will receive while this person is away.
This e-mail is confidential and, if you are not the intended recipient, please 
return it to us and do not retain or disclose it. We filter and monitor e-mails 
in order to protect our system and the integrity, confidentiality and 
availability of e-mails. We cannot guarantee that e-mails are risk free and are 
not responsible for any related damage or unauthorised alteration of e-mails by 
third parties after sending. 

For more information on Standard Life group, visit our website  
http://www.standardlife.com/ 

Standard Life plc (SC286832), Standard Life Assurance Limited* (SC286833) and 
Standard Life Employee Services Limited (SC271355) are all registered in 
Scotland at Standard Life House, 30 Lothian Road, Edinburgh EH1 2DH. 
*Authorised and regulated by the Financial Services Authority. 0131 225 2552. 
Calls may be recorded/monitored. Standard Life group includes Standard Life plc 
and its subsidiaries.  

-- 
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$$ Run-time error popup message

[Lokesh Loki]

Hi All,

Still i am not getting reply from the experts. Please do the needful.

Regards
Lokesh.M

On Thu, Aug 2, 2012 at 5:59 PM, lokesh  wrote:

>  Hi All,
>
>  
>
> When I am clicked the Get Report to know monthly report I got the error
> popup message window saying that “Run-time error’13 in VBA’” , hence I did
> not get the monthly report. 
>
>  
>
> Please find the above attached print screen of VBA line error and do the
> needful.
>
> ** **
>
> ** **
>
> 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$$ Noorain Ansari - Most Helpful Member July 2012

[dguillett1]

Good work!

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

From: Ayush Jain 
Sent: Friday, August 03, 2012 12:40 PM
To: excel-macros 
Subject: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

Dear members,

Noorain Ansari has been selected as 'Most Helpful Member' for the month of 
July'12. He has posted 143 posts in July 2012 and helped many forum members 
through his excel expertise.
 
I truly appreciate his consistency and commitment to the group. He is really 
doing great job.
 
Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince, Sunita and 
other folks for helping excel enthusiasts voluntarily !! 
Keep posting.
 
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$$ Marquee text in Powerpoint

[David Grugeon]

You might do better asking PowerPoint questions on a Powerpoint forum.  As
its name indicates this forum is about Excel Macros.

On 4 August 2012 02:24, rekha siri  wrote:

> Hi Experts,
>
> Please assist in this concern i deal with xlius earlier now we are using
> only power point dashboard presentation.
>
> is there any possibility to place the scrolling marquee kind of text as
> Headings of power point slides.
>
> which needs to be scrolling continously.
>
>
> Thanks,
> Rekha
>
> --
> 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
David Grugeon

-- 
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$$ Noorain Ansari - Most Helpful Member July 2012

[Asa Rossoff]

Congratulations Noorain!

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush Jain
Sent: Friday, August 03, 2012 10:40 AM
To: excel-macros
Subject: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

 

Dear members,

 
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
July'12. He has posted 143 posts in July 2012 and helped many forum members
through his excel expertise.
 
I truly appreciate his consistency and commitment to the group. He is really
doing great job.
 
Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince, Sunita
and other folks for helping excel enthusiasts voluntarily !! 
Keep posting.
 
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$$ Noorain Ansari - Most Helpful Member July 2012

[respuzy]

Congrats Boss. Keep up the momentum
Sent from my BlackBerry® smartphone from Airtel Ghana

-Original Message-
From: Ayush Jain 
Sender: excel-macros@googlegroups.com
Date: Fri, 3 Aug 2012 23:10:25 
To: excel-macros
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

Dear members,

Noorain Ansari has been selected as 'Most Helpful Member' for the month of
July'12. He has posted 143 posts in July 2012 and helped many forum members
through his excel expertise.

I truly appreciate his consistency and commitment to the group. He is
really doing great job.

Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince, Sunita
and other folks for helping excel enthusiasts voluntarily !!
Keep posting.

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$$ Noorain Ansari - Most Helpful Member July 2012

[Sam Mathai Chacko]

Congrats Noorain. As always, your contributions help many.

Regards,
Sam Mathai Chacko

On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain  wrote:

> Dear members,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> July'12. He has posted 143 posts in July 2012 and helped many forum members
> through his excel expertise.
>
> I truly appreciate his consistency and commitment to the group. He is
> really doing great job.
>
> Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince,
> Sunita and other folks for helping excel enthusiasts voluntarily !!
> Keep posting.
>
> 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
>
>
>



-- 
Sam Mathai Chacko

-- 
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$$ Trace Precedents and Trace Error

[Prince Dubey]

Hi Sam,

Nice Answer. I wanted to ask this question before well doesn't matter to 
me, I got my answer.

regards
Prince 

On Friday, August 3, 2012 9:34:10 PM UTC+5:30, Sam Mathai Chacko wrote:
>
> Trace Precendents and Trace Error is different from each other literally 
> as it sounds. For any single cell containing any formula, its precedents 
> are nothing but any cell or cells that it references in that formula.
>
> Trace Error on the other hand for any single cell containing any formula, 
> is the precedent cell or cells in that formula that have an error.
>
> So a cell traced using the Trace Error will always be a precedent cell of 
> that cell, but a cell traced using the Trace Precedents will not 
> necessarily have an error to be traced with the Trace Error feature.
>
> Regards,
> Sam
>
> On Fri, Aug 3, 2012 at 8:42 PM, Rajan_Verma wrote:
>
>> * *
>>
>> *Hi Group,*
>>
>> * *
>>
>> *Is there any difference in Trace Precedents and Trace Error in Excel??*
>>
>> * *
>>
>> *I don’t need any link to see because  I have already Google it.*
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> ** **
>>  
>> -- 
>> 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
>>  
>>  
>>
>
>
>
> -- 
> Sam Mathai Chacko
>

-- 
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$$ Oracle DBA West Norristown, PA 6+ Months

[Prince Dubey]

Gys please don't post anything that is related with job posting.
On Friday, August 3, 2012 10:37:55 PM UTC+5:30, NOORAIN ANSARI wrote:
>
> Dear andrew,
>
> Job posting is ban here.
> Sent from BlackBerry® on Airtel
> --
> *From: * Andrew Thomas  
> *Sender: * excel-macros@googlegroups.com 
> *Date: *Fri, 3 Aug 2012 22:03:52 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com 
> *Subject: *$$Excel-Macros$$ Oracle DBA West Norristown, PA 6+ Months
>
> *Oracle DBA
> West Norristown, PA*
> *6+ Months*
>
>
>
>
> 7+ years working experience as a DBA
> 5+ years working experience on Unix/Linux
> Experience managing multi-terabyte databases.
> Proficient experience with Oracle 9i/10g/11g.
> Ability to design, implement and support Oracle production databases for 
> high
> availability, security, manageability and reliability.
> 6. Proficiency in Oracle partitioning, RAC, ASM, Advanced Security, Data 
> Encryption, Active
> Data Guard
> 7. Proficiency in Oracle database administration on Linux, AIX, HP-UX, 
> Solaris Operating
> systems
> 8. Proficiency in Oracle upgrades/migrations from 9i/10 to 11g.
> 9. Proficiency in Oracle backup and recovery techniques including RMAN, 
> Networker
> backups
> 10. Experience in Patching and database refreshes using Data pump, RMAN 
> methods.
> 11. Proficiency in advanced Performance Tuning - SQL, I/O and Application 
> tuning,
> transaction monitoring, detecting resource contentions
>
>
> 12. Knowledge of Oracle Golden Gate.
> 13. Experience in managing large Data Warehouse environments.
> Desirable Qualifications:
> 1. OEM Repository Installation and configuring with various databases, 
> nodes and
> instances. Configuration of events, jobs and reports for Instance, node, 
> server
> monitoring through Grid Control.
> 2. Proficiency in data migration, data archiving and data access 
> techniques.
> 3. Experience in implementing PCI and SOX regulatory compliances for 
> Oracle databases.
> 4. Experience in Golden Gate Implementations.
> 5. Proficiency in maintaining Database Standards, Reviews, Documentation, 
> Quality
> Assurance
> 6. Design, test and implement Disaster Recovery and Contingency Plans for 
> databases,
> data centers and mission critical instances and applications.
> 7. Strong knowledge or Oracle & PL/ SQL, Unix and shell scripting
>
> Project
> It is desired that the capacity candidate know how to construct capacity 
> models that reflect
> trend growth of current resources and project long term KPIs. The candidate 
>
> -- 
> 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$$ Noorain Ansari - Most Helpful Member July 2012

[Ayush Jain]

Dear members,

Noorain Ansari has been selected as 'Most Helpful Member' for the month of
July'12. He has posted 143 posts in July 2012 and helped many forum members
through his excel expertise.

I truly appreciate his consistency and commitment to the group. He is
really doing great job.

Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince, Sunita
and other folks for helping excel enthusiasts voluntarily !!
Keep posting.

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

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

[ChilExcel]

Mr Sam Mathai Chacko

Yes i make  last comment ...!!

You start a discussion unutil only to draw attention?
or just bothering
I do not know how you use your time  but mine is important
Now yes.. I end up here


Chilexcel





2012/8/3 Sam Mathai Chacko 

> :) ending this here. No comments
>
>
> On Fri, Aug 3, 2012 at 10:27 PM, ChilExcel  wrote:
>
>> 1) I'm trying to say is that no matter if 1 or 2
>>to response, if bad or good response anrterior
>> just answer something to contribute and you!
>>
>>  2) yes is a copy of (
>> http://www.dummies.com/how-to/content/understanding-excel-2010s-formula-auditing-tools.html)
>>   You will not wait to draft all the text again, there is an effort by
>> someone else, ..thanks for posting the link
>>  3) I clearly understand the question,  you are who do not understand
>>  rajan did not want links or anything He wanted an answer
>> this reviewer Rajan.. is what matters !!!
>>
>>
>> Chilexcel
>>
>>
>>
>>
>>
>> 2012/8/3 Sam Mathai Chacko 
>>
>>> 1. Your post came on top of my post, so there is no way of me proposing
>>> 'another' solution.
>>>
>>> 2. It is not your answer (
>>> http://www.dummies.com/how-to/content/understanding-excel-2010s-formula-auditing-tools.html
>>> )
>>>
>>> 3. There is no reason to feel offended. I was only saying that it was a
>>> different question, and you probably (apparently) didn't understand what
>>> was asked.
>>>
>>> Sam
>>>
>>>
>>> On Fri, Aug 3, 2012 at 9:51 PM, ChilExcel wrote:
>>>
 Mr.Sam Mathai Chacko

 I only answer queries or questions .. if you do not like my answer
 you propose another solution .. and everyone happy!!!


 Chilexcel



 2012/8/3 Sam Mathai Chacko 

> Rajan isn't asking about Formula Auditing, which I am sure he is aware
> of. His question is about the difference between Trace Precedents and 
> Trace
> Error which are two separate features in Excel.
>
> Please read my post before.
>
> Regards,
> Sam Mathai Chacko
>
>
> On Fri, Aug 3, 2012 at 9:34 PM, ChilExcel wrote:
>
>> Rajan
>>
>>
>>
>> These tool in Excel allows us to Trace Precedents in a formula, Trace
>> Dependents , Show formulas, Error checking and Evaluating formula in 
>> Excel.
>> [image: Imágenes integradas 1]
>>
>> detail
>>
>>
>> *Trace Precedents:* When you click this button, Excel draws arrows
>> to the cells (the so-called *direct precedents*) that are referred
>> to in the formula inside the selected cell. When you click this button
>> again, Excel adds "tracer" arrows that show the cells (the so-called
>> *indirect precedents*) that are referred to in the formulas in the
>> direct precedents.
>>
>> *Trace Dependents:* When you click this button, Excel draws arrows
>> from the selected cell to the cells (the so-called *direct dependents
>> *) that use, or depend on, the results of the formula in the
>> selected cell. When you click this button again, Excel adds tracer arrows
>> identifying the cells (the so-called *indirect dependents*) that
>> refer to formulas found in the direct dependents.
>>
>> *Remove Arrows:* Clicking this button (or the Remove Arrows option
>> on its drop-down menu) removes all the arrows drawn, no matter what 
>> button
>> or command you used to put them there.
>>
>> *Show Formulas:* To display all formulas in their cells in the
>> worksheet instead of their calculated values (just like pressing Ctrl+`).
>> • *Error Checking*: When you click this button or the Error Checking
>> option on its drop-down menu, Excel displays the Error Checking dialog 
>> box,
>> which describes the nature of the error in the current cell, gives you 
>> help
>> on it, and enables you to trace its precedents. Click the Trace Error
>> option on this button's drop-down menu to attempt to locate the cell that
>> contains the original formula that has an error. Click the Circular
>> References option on this button's drop-down menu to display a menu with 
>> a
>> list of all the cell addresses containing circular references in the 
>> active
>> worksheet.
>>
>>
>> *Evaluate Formula:* Clicking this button opens the Evaluate Formula
>> dialog box, where you can have Excel evaluate each part of the formula in
>> the current cell. The Evaluate Formula feature can be quite useful in
>> formulas that nest many functions within them.
>>
>> Chilexcel
>>
>>  2012/8/3 Rajan_Verma 
>>
>>>  * *
>>>
>>> *Hi Group,*
>>>
>>> * *
>>>
>>> *Is there any difference in Trace Precedents and Trace Error in
>>> Excel??*
>>>
>>> * *
>>>
>>> *I don’t need any link to see because  I have already Google it.*
>>>
>>> * *
>>>
>>> *Regards*
>>>
>>> *Rajan verm

Re: $$Excel-Macros$$ Oracle DBA West Norristown, PA 6+ Months

[noorain . ansari]

Dear andrew,

Job posting is ban here.

Sent from BlackBerry® on Airtel

-Original Message-
From: Andrew Thomas 
Sender: excel-macros@googlegroups.com
Date: Fri, 3 Aug 2012 22:03:52 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Oracle DBA West Norristown, PA 6+ Months

*Oracle DBA
West Norristown, PA*
*6+ Months*




7+ years working experience as a DBA
5+ years working experience on Unix/Linux
Experience managing multi-terabyte databases.
Proficient experience with Oracle 9i/10g/11g.
Ability to design, implement and support Oracle production databases for
high
availability, security, manageability and reliability.
6. Proficiency in Oracle partitioning, RAC, ASM, Advanced Security, Data
Encryption, Active
Data Guard
7. Proficiency in Oracle database administration on Linux, AIX, HP-UX,
Solaris Operating
systems
8. Proficiency in Oracle upgrades/migrations from 9i/10 to 11g.
9. Proficiency in Oracle backup and recovery techniques including RMAN,
Networker
backups
10. Experience in Patching and database refreshes using Data pump, RMAN
methods.
11. Proficiency in advanced Performance Tuning - SQL, I/O and Application
tuning,
transaction monitoring, detecting resource contentions


12. Knowledge of Oracle Golden Gate.
13. Experience in managing large Data Warehouse environments.
Desirable Qualifications:
1. OEM Repository Installation and configuring with various databases,
nodes and
instances. Configuration of events, jobs and reports for Instance, node,
server
monitoring through Grid Control.
2. Proficiency in data migration, data archiving and data access techniques.
3. Experience in implementing PCI and SOX regulatory compliances for Oracle
databases.
4. Experience in Golden Gate Implementations.
5. Proficiency in maintaining Database Standards, Reviews, Documentation,
Quality
Assurance
6. Design, test and implement Disaster Recovery and Contingency Plans for
databases,
data centers and mission critical instances and applications.
7. Strong knowledge or Oracle & PL/ SQL, Unix and shell scripting

Project
It is desired that the capacity candidate know how to construct capacity
models that reflect
trend growth of current resources and project long term KPIs. The candidate

-- 
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$$ Trace Precedents and Trace Error

[Sam Mathai Chacko]

:) ending this here. No comments

On Fri, Aug 3, 2012 at 10:27 PM, ChilExcel  wrote:

> 1) I'm trying to say is that no matter if 1 or 2
>to response, if bad or good response anrterior
> just answer something to contribute and you!
>
>  2) yes is a copy of (
> http://www.dummies.com/how-to/content/understanding-excel-2010s-formula-auditing-tools.html)
>   You will not wait to draft all the text again, there is an effort by
> someone else, ..thanks for posting the link
>  3) I clearly understand the question,  you are who do not understand
>  rajan did not want links or anything He wanted an answer
> this reviewer Rajan.. is what matters !!!
>
>
> Chilexcel
>
>
>
>
>
> 2012/8/3 Sam Mathai Chacko 
>
>> 1. Your post came on top of my post, so there is no way of me proposing
>> 'another' solution.
>>
>> 2. It is not your answer (
>> http://www.dummies.com/how-to/content/understanding-excel-2010s-formula-auditing-tools.html
>> )
>>
>> 3. There is no reason to feel offended. I was only saying that it was a
>> different question, and you probably (apparently) didn't understand what
>> was asked.
>>
>> Sam
>>
>>
>> On Fri, Aug 3, 2012 at 9:51 PM, ChilExcel  wrote:
>>
>>> Mr.Sam Mathai Chacko
>>>
>>> I only answer queries or questions .. if you do not like my answer
>>> you propose another solution .. and everyone happy!!!
>>>
>>>
>>> Chilexcel
>>>
>>>
>>>
>>> 2012/8/3 Sam Mathai Chacko 
>>>
 Rajan isn't asking about Formula Auditing, which I am sure he is aware
 of. His question is about the difference between Trace Precedents and Trace
 Error which are two separate features in Excel.

 Please read my post before.

 Regards,
 Sam Mathai Chacko


 On Fri, Aug 3, 2012 at 9:34 PM, ChilExcel wrote:

> Rajan
>
>
>
> These tool in Excel allows us to Trace Precedents in a formula, Trace
> Dependents , Show formulas, Error checking and Evaluating formula in 
> Excel.
> [image: Imágenes integradas 1]
>
> detail
>
>
> *Trace Precedents:* When you click this button, Excel draws arrows to
> the cells (the so-called *direct precedents*) that are referred to in
> the formula inside the selected cell. When you click this button again,
> Excel adds "tracer" arrows that show the cells (the so-called *indirect
> precedents*) that are referred to in the formulas in the direct
> precedents.
>
> *Trace Dependents:* When you click this button, Excel draws arrows
> from the selected cell to the cells (the so-called *direct dependents*)
> that use, or depend on, the results of the formula in the selected cell.
> When you click this button again, Excel adds tracer arrows identifying the
> cells (the so-called *indirect dependents*) that refer to formulas
> found in the direct dependents.
>
> *Remove Arrows:* Clicking this button (or the Remove Arrows option on
> its drop-down menu) removes all the arrows drawn, no matter what button or
> command you used to put them there.
>
> *Show Formulas:* To display all formulas in their cells in the
> worksheet instead of their calculated values (just like pressing Ctrl+`).
> • *Error Checking*: When you click this button or the Error Checking
> option on its drop-down menu, Excel displays the Error Checking dialog 
> box,
> which describes the nature of the error in the current cell, gives you 
> help
> on it, and enables you to trace its precedents. Click the Trace Error
> option on this button's drop-down menu to attempt to locate the cell that
> contains the original formula that has an error. Click the Circular
> References option on this button's drop-down menu to display a menu with a
> list of all the cell addresses containing circular references in the 
> active
> worksheet.
>
>
> *Evaluate Formula:* Clicking this button opens the Evaluate Formula
> dialog box, where you can have Excel evaluate each part of the formula in
> the current cell. The Evaluate Formula feature can be quite useful in
> formulas that nest many functions within them.
>
> Chilexcel
>
>  2012/8/3 Rajan_Verma 
>
>>  * *
>>
>> *Hi Group,*
>>
>> * *
>>
>> *Is there any difference in Trace Precedents and Trace Error in
>> Excel??*
>>
>> * *
>>
>> *I don’t need any link to see because  I have already Google it.*
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> ** **
>>
>> --
>> 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 o

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

[ChilExcel]

1) I'm trying to say is that no matter if 1 or 2
   to response, if bad or good response anrterior
just answer something to contribute and you!

 2) yes is a copy of (
http://www.dummies.com/how-to/content/understanding-excel-2010s-formula-auditing-tools.html)
  You will not wait to draft all the text again, there is an effort by
someone else, ..thanks for posting the link
 3) I clearly understand the question,  you are who do not understand
 rajan did not want links or anything He wanted an answer
this reviewer Rajan.. is what matters !!!


Chilexcel





2012/8/3 Sam Mathai Chacko 

> 1. Your post came on top of my post, so there is no way of me proposing
> 'another' solution.
>
> 2. It is not your answer (
> http://www.dummies.com/how-to/content/understanding-excel-2010s-formula-auditing-tools.html
> )
>
> 3. There is no reason to feel offended. I was only saying that it was a
> different question, and you probably (apparently) didn't understand what
> was asked.
>
> Sam
>
>
> On Fri, Aug 3, 2012 at 9:51 PM, ChilExcel  wrote:
>
>> Mr.Sam Mathai Chacko
>>
>> I only answer queries or questions .. if you do not like my answer
>> you propose another solution .. and everyone happy!!!
>>
>>
>> Chilexcel
>>
>>
>>
>> 2012/8/3 Sam Mathai Chacko 
>>
>>> Rajan isn't asking about Formula Auditing, which I am sure he is aware
>>> of. His question is about the difference between Trace Precedents and Trace
>>> Error which are two separate features in Excel.
>>>
>>> Please read my post before.
>>>
>>> Regards,
>>> Sam Mathai Chacko
>>>
>>>
>>> On Fri, Aug 3, 2012 at 9:34 PM, ChilExcel wrote:
>>>
 Rajan



 These tool in Excel allows us to Trace Precedents in a formula, Trace
 Dependents , Show formulas, Error checking and Evaluating formula in Excel.
 [image: Imágenes integradas 1]

 detail


 *Trace Precedents:* When you click this button, Excel draws arrows to
 the cells (the so-called *direct precedents*) that are referred to in
 the formula inside the selected cell. When you click this button again,
 Excel adds "tracer" arrows that show the cells (the so-called *indirect
 precedents*) that are referred to in the formulas in the direct
 precedents.

 *Trace Dependents:* When you click this button, Excel draws arrows
 from the selected cell to the cells (the so-called *direct dependents*)
 that use, or depend on, the results of the formula in the selected cell.
 When you click this button again, Excel adds tracer arrows identifying the
 cells (the so-called *indirect dependents*) that refer to formulas
 found in the direct dependents.

 *Remove Arrows:* Clicking this button (or the Remove Arrows option on
 its drop-down menu) removes all the arrows drawn, no matter what button or
 command you used to put them there.

 *Show Formulas:* To display all formulas in their cells in the
 worksheet instead of their calculated values (just like pressing Ctrl+`).
 • *Error Checking*: When you click this button or the Error Checking
 option on its drop-down menu, Excel displays the Error Checking dialog box,
 which describes the nature of the error in the current cell, gives you help
 on it, and enables you to trace its precedents. Click the Trace Error
 option on this button's drop-down menu to attempt to locate the cell that
 contains the original formula that has an error. Click the Circular
 References option on this button's drop-down menu to display a menu with a
 list of all the cell addresses containing circular references in the active
 worksheet.


 *Evaluate Formula:* Clicking this button opens the Evaluate Formula
 dialog box, where you can have Excel evaluate each part of the formula in
 the current cell. The Evaluate Formula feature can be quite useful in
 formulas that nest many functions within them.

 Chilexcel

  2012/8/3 Rajan_Verma 

>  * *
>
> *Hi Group,*
>
> * *
>
> *Is there any difference in Trace Precedents and Trace Error in
> Excel??*
>
> * *
>
> *I don’t need any link to see because  I have already Google it.*
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> --
> 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
> i

RE: $$Excel-Macros$$ Trace Precedents and Trace Error

[Rajan_Verma]

Thank chile.

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ChilExcel
Sent: 03 August 2012 9:34
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Trace Precedents and Trace Error

 

Rajan 

 


These tool in Excel allows us to Trace Precedents in a formula, Trace
Dependents , Show formulas, Error checking and Evaluating formula in Excel.

Imágenes integradas 1

 

detail

 

·  Trace Precedents: When you click this button, Excel draws arrows to the
cells (the so-called direct precedents) that are referred to in the formula
inside the selected cell. When you click this button again, Excel adds
"tracer" arrows that show the cells (the so-called indirect precedents) that
are referred to in the formulas in the direct precedents.

·  Trace Dependents: When you click this button, Excel draws arrows from the
selected cell to the cells (the so-called direct dependents) that use, or
depend on, the results of the formula in the selected cell. When you click
this button again, Excel adds tracer arrows identifying the cells (the
so-called indirect dependents) that refer to formulas found in the direct
dependents.

·  Remove Arrows: Clicking this button (or the Remove Arrows option on its
drop-down menu) removes all the arrows drawn, no matter what button or
command you used to put them there. 

·  Show Formulas: To display all formulas in their cells in the worksheet
instead of their calculated values (just like pressing Ctrl+`).

• Error Checking: When you click this button or the Error Checking option on
its drop-down menu, Excel displays the Error Checking dialog box, which
describes the nature of the error in the current cell, gives you help on it,
and enables you to trace its precedents. Click the Trace Error option on
this button's drop-down menu to attempt to locate the cell that contains the
original formula that has an error. Click the Circular References option on
this button's drop-down menu to display a menu with a list of all the cell
addresses containing circular references in the active worksheet.

 

·  Evaluate Formula: Clicking this button opens the Evaluate Formula dialog
box, where you can have Excel evaluate each part of the formula in the
current cell. The Evaluate Formula feature can be quite useful in formulas
that nest many functions within them.

 

Chilexcel

2012/8/3 Rajan_Verma 

 

Hi Group,

 

Is there any difference in Trace Precedents and Trace Error in Excel??

 

I don’t need any link to see because  I have already Google it.

 

Regards

Rajan verma

+91 7838100659   [IM-Gtalk]

 

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




-- 

Visita ; http://sites.google.com/site/chilexcel/Home

Visita ; http://www.youtube.com/user/timextag41

 

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

RE: $$Excel-Macros$$ Trace Precedents and Trace Error

[Rajan_Verma]

Thanks Sam, answer was really helpful.

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sam Mathai Chacko
Sent: 03 August 2012 9:34
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Trace Precedents and Trace Error

 

Trace Precendents and Trace Error is different from each other literally as
it sounds. For any single cell containing any formula, its precedents are
nothing but any cell or cells that it references in that formula.

Trace Error on the other hand for any single cell containing any formula, is
the precedent cell or cells in that formula that have an error.

So a cell traced using the Trace Error will always be a precedent cell of
that cell, but a cell traced using the Trace Precedents will not necessarily
have an error to be traced with the Trace Error feature.

Regards,
Sam

On Fri, Aug 3, 2012 at 8:42 PM, Rajan_Verma 
wrote:

 

Hi Group,

 

Is there any difference in Trace Precedents and Trace Error in Excel??

 

I don't need any link to see because  I have already Google it.

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

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




-- 
Sam Mathai Chacko

-- 
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$$ Oracle DBA West Norristown, PA 6+ Months

[Andrew Thomas]

*Oracle DBA
West Norristown, PA*
*6+ Months*




7+ years working experience as a DBA
5+ years working experience on Unix/Linux
Experience managing multi-terabyte databases.
Proficient experience with Oracle 9i/10g/11g.
Ability to design, implement and support Oracle production databases for
high
availability, security, manageability and reliability.
6. Proficiency in Oracle partitioning, RAC, ASM, Advanced Security, Data
Encryption, Active
Data Guard
7. Proficiency in Oracle database administration on Linux, AIX, HP-UX,
Solaris Operating
systems
8. Proficiency in Oracle upgrades/migrations from 9i/10 to 11g.
9. Proficiency in Oracle backup and recovery techniques including RMAN,
Networker
backups
10. Experience in Patching and database refreshes using Data pump, RMAN
methods.
11. Proficiency in advanced Performance Tuning - SQL, I/O and Application
tuning,
transaction monitoring, detecting resource contentions


12. Knowledge of Oracle Golden Gate.
13. Experience in managing large Data Warehouse environments.
Desirable Qualifications:
1. OEM Repository Installation and configuring with various databases,
nodes and
instances. Configuration of events, jobs and reports for Instance, node,
server
monitoring through Grid Control.
2. Proficiency in data migration, data archiving and data access techniques.
3. Experience in implementing PCI and SOX regulatory compliances for Oracle
databases.
4. Experience in Golden Gate Implementations.
5. Proficiency in maintaining Database Standards, Reviews, Documentation,
Quality
Assurance
6. Design, test and implement Disaster Recovery and Contingency Plans for
databases,
data centers and mission critical instances and applications.
7. Strong knowledge or Oracle & PL/ SQL, Unix and shell scripting

Project
It is desired that the capacity candidate know how to construct capacity
models that reflect
trend growth of current resources and project long term KPIs. The candidate

-- 
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$$ Trace Precedents and Trace Error

[Sam Mathai Chacko]

1. Your post came on top of my post, so there is no way of me proposing
'another' solution.

2. It is not your answer (
http://www.dummies.com/how-to/content/understanding-excel-2010s-formula-auditing-tools.html
)

3. There is no reason to feel offended. I was only saying that it was a
different question, and you probably (apparently) didn't understand what
was asked.

Sam

On Fri, Aug 3, 2012 at 9:51 PM, ChilExcel  wrote:

> Mr.Sam Mathai Chacko
>
> I only answer queries or questions .. if you do not like my answer
> you propose another solution .. and everyone happy!!!
>
>
> Chilexcel
>
>
>
> 2012/8/3 Sam Mathai Chacko 
>
>> Rajan isn't asking about Formula Auditing, which I am sure he is aware
>> of. His question is about the difference between Trace Precedents and Trace
>> Error which are two separate features in Excel.
>>
>> Please read my post before.
>>
>> Regards,
>> Sam Mathai Chacko
>>
>>
>> On Fri, Aug 3, 2012 at 9:34 PM, ChilExcel  wrote:
>>
>>> Rajan
>>>
>>>
>>>
>>> These tool in Excel allows us to Trace Precedents in a formula, Trace
>>> Dependents , Show formulas, Error checking and Evaluating formula in Excel.
>>> [image: Imágenes integradas 1]
>>>
>>> detail
>>>
>>>
>>> *Trace Precedents:* When you click this button, Excel draws arrows to
>>> the cells (the so-called *direct precedents*) that are referred to in
>>> the formula inside the selected cell. When you click this button again,
>>> Excel adds "tracer" arrows that show the cells (the so-called *indirect
>>> precedents*) that are referred to in the formulas in the direct
>>> precedents.
>>>
>>> *Trace Dependents:* When you click this button, Excel draws arrows from
>>> the selected cell to the cells (the so-called *direct dependents*) that
>>> use, or depend on, the results of the formula in the selected cell. When
>>> you click this button again, Excel adds tracer arrows identifying the cells
>>> (the so-called *indirect dependents*) that refer to formulas found in
>>> the direct dependents.
>>>
>>> *Remove Arrows:* Clicking this button (or the Remove Arrows option on
>>> its drop-down menu) removes all the arrows drawn, no matter what button or
>>> command you used to put them there.
>>>
>>> *Show Formulas:* To display all formulas in their cells in the
>>> worksheet instead of their calculated values (just like pressing Ctrl+`).
>>> • *Error Checking*: When you click this button or the Error Checking
>>> option on its drop-down menu, Excel displays the Error Checking dialog box,
>>> which describes the nature of the error in the current cell, gives you help
>>> on it, and enables you to trace its precedents. Click the Trace Error
>>> option on this button's drop-down menu to attempt to locate the cell that
>>> contains the original formula that has an error. Click the Circular
>>> References option on this button's drop-down menu to display a menu with a
>>> list of all the cell addresses containing circular references in the active
>>> worksheet.
>>>
>>>
>>> *Evaluate Formula:* Clicking this button opens the Evaluate Formula
>>> dialog box, where you can have Excel evaluate each part of the formula in
>>> the current cell. The Evaluate Formula feature can be quite useful in
>>> formulas that nest many functions within them.
>>>
>>> Chilexcel
>>>
>>>  2012/8/3 Rajan_Verma 
>>>
  * *

 *Hi Group,*

 * *

 *Is there any difference in Trace Precedents and Trace Error in Excel??
 *

 * *

 *I don’t need any link to see because  I have already Google it.*

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 ** **

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



>>>
>>>
>>>
>>> --
>>> Visita ; http://sites.google.com/site/chilexcel/Home
>>> Visita ; http://www.youtube.com/user/timextag41
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like 

$$Excel-Macros$$ Marquee text in Powerpoint

[rekha siri]

Hi Experts,

Please assist in this concern i deal with xlius earlier now we are using
only power point dashboard presentation.

is there any possibility to place the scrolling marquee kind of text as
Headings of power point slides.

which needs to be scrolling continously.


Thanks,
Rekha

-- 
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$$ Trace Precedents and Trace Error

[ChilExcel]

Mr.Sam Mathai Chacko

I only answer queries or questions .. if you do not like my answer
you propose another solution .. and everyone happy!!!


Chilexcel



2012/8/3 Sam Mathai Chacko 

> Rajan isn't asking about Formula Auditing, which I am sure he is aware of.
> His question is about the difference between Trace Precedents and Trace
> Error which are two separate features in Excel.
>
> Please read my post before.
>
> Regards,
> Sam Mathai Chacko
>
>
> On Fri, Aug 3, 2012 at 9:34 PM, ChilExcel  wrote:
>
>> Rajan
>>
>>
>>
>> These tool in Excel allows us to Trace Precedents in a formula, Trace
>> Dependents , Show formulas, Error checking and Evaluating formula in Excel.
>> [image: Imágenes integradas 1]
>>
>> detail
>>
>>
>> *Trace Precedents:* When you click this button, Excel draws arrows to
>> the cells (the so-called *direct precedents*) that are referred to in
>> the formula inside the selected cell. When you click this button again,
>> Excel adds "tracer" arrows that show the cells (the so-called *indirect
>> precedents*) that are referred to in the formulas in the direct
>> precedents.
>>
>> *Trace Dependents:* When you click this button, Excel draws arrows from
>> the selected cell to the cells (the so-called *direct dependents*) that
>> use, or depend on, the results of the formula in the selected cell. When
>> you click this button again, Excel adds tracer arrows identifying the cells
>> (the so-called *indirect dependents*) that refer to formulas found in
>> the direct dependents.
>>
>> *Remove Arrows:* Clicking this button (or the Remove Arrows option on
>> its drop-down menu) removes all the arrows drawn, no matter what button or
>> command you used to put them there.
>>
>> *Show Formulas:* To display all formulas in their cells in the worksheet
>> instead of their calculated values (just like pressing Ctrl+`).
>> • *Error Checking*: When you click this button or the Error Checking
>> option on its drop-down menu, Excel displays the Error Checking dialog box,
>> which describes the nature of the error in the current cell, gives you help
>> on it, and enables you to trace its precedents. Click the Trace Error
>> option on this button's drop-down menu to attempt to locate the cell that
>> contains the original formula that has an error. Click the Circular
>> References option on this button's drop-down menu to display a menu with a
>> list of all the cell addresses containing circular references in the active
>> worksheet.
>>
>>
>> *Evaluate Formula:* Clicking this button opens the Evaluate Formula
>> dialog box, where you can have Excel evaluate each part of the formula in
>> the current cell. The Evaluate Formula feature can be quite useful in
>> formulas that nest many functions within them.
>>
>> Chilexcel
>>
>>  2012/8/3 Rajan_Verma 
>>
>>>  * *
>>>
>>> *Hi Group,*
>>>
>>> * *
>>>
>>> *Is there any difference in Trace Precedents and Trace Error in Excel??*
>>>
>>> * *
>>>
>>> *I don’t need any link to see because  I have already Google it.*
>>>
>>> * *
>>>
>>> *Regards*
>>>
>>> *Rajan verma*
>>>
>>> *+91 7838100659 [IM-Gtalk]*
>>>
>>> ** **
>>>
>>> --
>>> 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
>>>
>>>
>>>
>>
>>
>>
>> --
>> Visita ; http://sites.google.com/site/chilexcel/Home
>> Visita ; http://www.youtube.com/user/timextag41
>>
>> --
>> 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 responsi

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

[Sam Mathai Chacko]

Rajan isn't asking about Formula Auditing, which I am sure he is aware of.
His question is about the difference between Trace Precedents and Trace
Error which are two separate features in Excel.

Please read my post before.

Regards,
Sam Mathai Chacko

On Fri, Aug 3, 2012 at 9:34 PM, ChilExcel  wrote:

> Rajan
>
>
>
> These tool in Excel allows us to Trace Precedents in a formula, Trace
> Dependents , Show formulas, Error checking and Evaluating formula in Excel.
> [image: Imágenes integradas 1]
>
> detail
>
>
> *Trace Precedents:* When you click this button, Excel draws arrows to the
> cells (the so-called *direct precedents*) that are referred to in the
> formula inside the selected cell. When you click this button again, Excel
> adds "tracer" arrows that show the cells (the so-called *indirect
> precedents*) that are referred to in the formulas in the direct
> precedents.
>
> *Trace Dependents:* When you click this button, Excel draws arrows from
> the selected cell to the cells (the so-called *direct dependents*) that
> use, or depend on, the results of the formula in the selected cell. When
> you click this button again, Excel adds tracer arrows identifying the cells
> (the so-called *indirect dependents*) that refer to formulas found in the
> direct dependents.
>
> *Remove Arrows:* Clicking this button (or the Remove Arrows option on its
> drop-down menu) removes all the arrows drawn, no matter what button or
> command you used to put them there.
>
> *Show Formulas:* To display all formulas in their cells in the worksheet
> instead of their calculated values (just like pressing Ctrl+`).
> • *Error Checking*: When you click this button or the Error Checking
> option on its drop-down menu, Excel displays the Error Checking dialog box,
> which describes the nature of the error in the current cell, gives you help
> on it, and enables you to trace its precedents. Click the Trace Error
> option on this button's drop-down menu to attempt to locate the cell that
> contains the original formula that has an error. Click the Circular
> References option on this button's drop-down menu to display a menu with a
> list of all the cell addresses containing circular references in the active
> worksheet.
>
>
> *Evaluate Formula:* Clicking this button opens the Evaluate Formula
> dialog box, where you can have Excel evaluate each part of the formula in
> the current cell. The Evaluate Formula feature can be quite useful in
> formulas that nest many functions within them.
>
> Chilexcel
>
> 2012/8/3 Rajan_Verma 
>
>>  * *
>>
>> *Hi Group,*
>>
>> * *
>>
>> *Is there any difference in Trace Precedents and Trace Error in Excel??*
>>
>> * *
>>
>> *I don’t need any link to see because  I have already Google it.*
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> ** **
>>
>> --
>> 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
>>
>>
>>
>
>
>
> --
> Visita ; http://sites.google.com/site/chilexcel/Home
> Visita ; http://www.youtube.com/user/timextag41
>
>  --
> 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
>
>
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (986+ mem

Re: $$Excel-Macros$$ Trace Precedents and Trace Error

[ChilExcel]

Rajan



These tool in Excel allows us to Trace Precedents in a formula, Trace
Dependents , Show formulas, Error checking and Evaluating formula in Excel.
[image: Imágenes integradas 1]

detail


*Trace Precedents:* When you click this button, Excel draws arrows to the
cells (the so-called *direct precedents*) that are referred to in the
formula inside the selected cell. When you click this button again, Excel
adds "tracer" arrows that show the cells (the so-called *indirect precedents
*) that are referred to in the formulas in the direct precedents.

*Trace Dependents:* When you click this button, Excel draws arrows from the
selected cell to the cells (the so-called *direct dependents*) that use, or
depend on, the results of the formula in the selected cell. When you click
this button again, Excel adds tracer arrows identifying the cells (the
so-called *indirect dependents*) that refer to formulas found in the direct
dependents.

*Remove Arrows:* Clicking this button (or the Remove Arrows option on its
drop-down menu) removes all the arrows drawn, no matter what button or
command you used to put them there.

*Show Formulas:* To display all formulas in their cells in the worksheet
instead of their calculated values (just like pressing Ctrl+`).
• *Error Checking*: When you click this button or the Error Checking option
on its drop-down menu, Excel displays the Error Checking dialog box, which
describes the nature of the error in the current cell, gives you help on
it, and enables you to trace its precedents. Click the Trace Error option
on this button's drop-down menu to attempt to locate the cell that contains
the original formula that has an error. Click the Circular References
option on this button's drop-down menu to display a menu with a list of all
the cell addresses containing circular references in the active worksheet.


*Evaluate Formula:* Clicking this button opens the Evaluate Formula dialog
box, where you can have Excel evaluate each part of the formula in the
current cell. The Evaluate Formula feature can be quite useful in formulas
that nest many functions within them.

Chilexcel

2012/8/3 Rajan_Verma 

>  * *
>
> *Hi Group,*
>
> * *
>
> *Is there any difference in Trace Precedents and Trace Error in Excel??*
>
> * *
>
> *I don’t need any link to see because  I have already Google it.*
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> --
> 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
>
>
>



-- 
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41

-- 
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$$ Trace Precedents and Trace Error

[Sam Mathai Chacko]

Trace Precendents and Trace Error is different from each other literally as
it sounds. For any single cell containing any formula, its precedents are
nothing but any cell or cells that it references in that formula.

Trace Error on the other hand for any single cell containing any formula,
is the precedent cell or cells in that formula that have an error.

So a cell traced using the Trace Error will always be a precedent cell of
that cell, but a cell traced using the Trace Precedents will not
necessarily have an error to be traced with the Trace Error feature.

Regards,
Sam

On Fri, Aug 3, 2012 at 8:42 PM, Rajan_Verma wrote:

> * *
>
> *Hi Group,*
>
> * *
>
> *Is there any difference in Trace Precedents and Trace Error in Excel??*
>
> * *
>
> *I don’t need any link to see because  I have already Google it.*
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> --
> 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
>
>
>



-- 
Sam Mathai Chacko

-- 
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$$ Trace Precedents and Trace Error

[Rajan_Verma]

 

Hi Group,

 

Is there any difference in Trace Precedents and Trace Error in Excel??

 

I don't need any link to see because  I have already Google it.

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

-- 
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$$ Fw: Urgent Help needed

[francis vinod]

Hi Don,

I never said my request is more urgent than other's request, since I didn't get 
any response to my earlier mail and I had to do some reporting so included the 
word 'urgent' in the subject line that's all.

 
Thanks & Regards,
Francis



 From: dguillett1 
To: excel-macros@googlegroups.com 
Sent: Friday, 3 August 2012 5:44 PM
Subject: Re: $$Excel-Macros$$ Fw: Urgent Help needed
 

Why is your request more urgent than the request of any of the 
others?
 
Don 
Guillett
Microsoft Excel Developer
SalesAid 
Software
dguille...@gmail.com 
From: francis vinod 
Sent: Friday, August 03, 2012 2:35 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Fw: Urgent Help needed
  Hello Experts,

Could you please provide me a solution on the below 
scenario.

Thanks & Regards,

Francis

- Forwarded Message -
From: francis vinod 

To: "excel-macros@googlegroups.com" 
 
Sent: Wednesday, 1 August 2012 6:54 
PM
Subject: Help 
needed

 
Hello Team, 


Could you please help me in the below scenario.
I have two different reports from which I have to prepare a single 
report for reporting purpose.
In sheet 1 the reports contains tracking#, HW details etc. & and sheet 
2 the report contains the values of the HW, tracking # 
etc

The report which I want should have the details of both Shee1 & 
Sheet 2 for which I have used the Vlookup formula and its fine.  The issue 
what I am facing is a single tracking # can have multiple line items and in the 
equipment report the equipments are split into seperate rows.  For eg, If a 
tracking # has 5 different equipments with discreptions in 5 lineitems then 
when 
I use a VLookup formula it only shows the detail of equipment in 1st 
line.

So I want your help on this so that I get all the 5 equipment details 
in my report.  


Please find attached the excel file with an example.

If you could guide me it would be a great help and learning for 
me.

 
Thanks & 
Regards,
Francis

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

$$Excel-Macros$$ Re: Excel to Access Data

[wirelesscellularguy]

Hi Swapnil,

Many thanks. I will practice with the samples shared by you and will 
consult you in case I find any issues.

Regards,
Wireless

On Friday, August 3, 2012 6:08:55 PM UTC+5:30, wirelesscellularguy wrote:
>
>
>
> On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>>
>> Hi All,
>>
>> I am trying to relate Access data & queries to excel. The excel will be 
>> the user interface. This excel will contain the various buttons to get 
>> specific informations and clicking these buttons will fetch the data from 
>> the access table or queries.
>>
>> Please suggest how it can be done.
>>
>> Sincere regards,
>> Wireless
>>
>
> On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>>
>> Hi All,
>>
>> I am trying to relate Access data & queries to excel. The excel will be 
>> the user interface. This excel will contain the various buttons to get 
>> specific informations and clicking these buttons will fetch the data from 
>> the access table or queries.
>>
>> Please suggest how it can be done.
>>
>> Sincere regards,
>> Wireless
>>
>
> On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>>
>> Hi All,
>>
>> I am trying to relate Access data & queries to excel. The excel will be 
>> the user interface. This excel will contain the various buttons to get 
>> specific informations and clicking these buttons will fetch the data from 
>> the access table or queries.
>>
>> Please suggest how it can be done.
>>
>> Sincere regards,
>> Wireless
>>
>
> On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>>
>> Hi All,
>>
>> I am trying to relate Access data & queries to excel. The excel will be 
>> the user interface. This excel will contain the various buttons to get 
>> specific informations and clicking these buttons will fetch the data from 
>> the access table or queries.
>>
>> Please suggest how it can be done.
>>
>> Sincere regards,
>> Wireless
>>
>
On Friday, August 3, 2012 6:08:55 PM UTC+5:30, wirelesscellularguy wrote:
>
>
>
> On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>>
>> Hi All,
>>
>> I am trying to relate Access data & queries to excel. The excel will be 
>> the user interface. This excel will contain the various buttons to get 
>> specific informations and clicking these buttons will fetch the data from 
>> the access table or queries.
>>
>> Please suggest how it can be done.
>>
>> Sincere regards,
>> Wireless
>>
>
> On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>>
>> Hi All,
>>
>> I am trying to relate Access data & queries to excel. The excel will be 
>> the user interface. This excel will contain the various buttons to get 
>> specific informations and clicking these buttons will fetch the data from 
>> the access table or queries.
>>
>> Please suggest how it can be done.
>>
>> Sincere regards,
>> Wireless
>>
>
> On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>>
>> Hi All,
>>
>> I am trying to relate Access data & queries to excel. The excel will be 
>> the user interface. This excel will contain the various buttons to get 
>> specific informations and clicking these buttons will fetch the data from 
>> the access table or queries.
>>
>> Please suggest how it can be done.
>>
>> Sincere regards,
>> Wireless
>>
>
> On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>>
>> Hi All,
>>
>> I am trying to relate Access data & queries to excel. The excel will be 
>> the user interface. This excel will contain the various buttons to get 
>> specific informations and clicking these buttons will fetch the data from 
>> the access table or queries.
>>
>> Please suggest how it can be done.
>>
>> Sincere regards,
>> Wireless
>>
>
On Friday, August 3, 2012 6:08:55 PM UTC+5:30, wirelesscellularguy wrote:
>
>
>
> On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>>
>> Hi All,
>>
>> I am trying to relate Access data & queries to excel. The excel will be 
>> the user interface. This excel will contain the various buttons to get 
>> specific informations and clicking these buttons will fetch the data from 
>> the access table or queries.
>>
>> Please suggest how it can be done.
>>
>> Sincere regards,
>> Wireless
>>
>
> On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>>
>> Hi All,
>>
>> I am trying to relate Access data & queries to excel. The excel will be 
>> the user interface. This excel will contain the various buttons to get 
>> specific informations and clicking these buttons will fetch the data from 
>> the access table or queries.
>>
>> Please suggest how it can be done.
>>
>> Sincere regards,
>> Wireless
>>
>
> On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>>
>> Hi All,
>>
>> I am trying to relate Access data & queries to excel. The excel will be 
>> the user interface. This excel will contain the various buttons to get 
>

$$Excel-Macros$$ Re: Excel to Access Data

[wirelesscellularguy]

On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>
> Hi All,
>
> I am trying to relate Access data & queries to excel. The excel will be 
> the user interface. This excel will contain the various buttons to get 
> specific informations and clicking these buttons will fetch the data from 
> the access table or queries.
>
> Please suggest how it can be done.
>
> Sincere regards,
> Wireless
>

On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>
> Hi All,
>
> I am trying to relate Access data & queries to excel. The excel will be 
> the user interface. This excel will contain the various buttons to get 
> specific informations and clicking these buttons will fetch the data from 
> the access table or queries.
>
> Please suggest how it can be done.
>
> Sincere regards,
> Wireless
>

On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>
> Hi All,
>
> I am trying to relate Access data & queries to excel. The excel will be 
> the user interface. This excel will contain the various buttons to get 
> specific informations and clicking these buttons will fetch the data from 
> the access table or queries.
>
> Please suggest how it can be done.
>
> Sincere regards,
> Wireless
>

On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>
> Hi All,
>
> I am trying to relate Access data & queries to excel. The excel will be 
> the user interface. This excel will contain the various buttons to get 
> specific informations and clicking these buttons will fetch the data from 
> the access table or queries.
>
> Please suggest how it can be done.
>
> Sincere regards,
> Wireless
>

-- 
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$$ Plz Help Me

[dguillett1]

When requesting help 
use a meaningful subject line
explain in the post and in the file what you want where, from where, and why, 
You sent a file and expected all to read your mind.
A look in the help index for COUNTIF would be helpful
Oh heck, HERE
  =COUNTIF(Report!I:I,C5) 


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

From: Anil Saxena 
Sent: Friday, August 03, 2012 6:28 AM
To: Dilip Pandey 
Cc: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Plz Help Me

Hi Dilip Sir, 

Plz find the attached file,

I want the Summary Sheet do the complicated in this Report. This Summary very 
Simple. Plz do the needful.

-- 
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$$ Fw: Urgent Help needed

[dguillett1]

Why is your request more urgent than the request of any of the others?

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

From: francis vinod 
Sent: Friday, August 03, 2012 2:35 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Fw: Urgent Help needed

Hello Experts,

Could you please provide me a solution on the below scenario.

Thanks & Regards,

Francis

- Forwarded Message -
From: francis vinod 
To: "excel-macros@googlegroups.com"  
Sent: Wednesday, 1 August 2012 6:54 PM
Subject: Help needed


Hello Team, 



Could you please help me in the below scenario.
I have two different reports from which I have to prepare a single report for 
reporting purpose.
In sheet 1 the reports contains tracking#, HW details etc. & and sheet 2 the 
report contains the values of the HW, tracking # etc

The report which I want should have the details of both Shee1 & Sheet 2 for 
which I have used the Vlookup formula and its fine.  The issue what I am facing 
is a single tracking # can have multiple line items and in the equipment report 
the equipments are split into seperate rows.  For eg, If a tracking # has 5 
different equipments with discreptions in 5 lineitems then when I use a VLookup 
formula it only shows the detail of equipment in 1st line.


So I want your help on this so that I get all the 5 equipment details in my 
report.  



Please find attached the excel file with an example.


If you could guide me it would be a great help and learning for me.


Thanks & Regards,
Francis



-- 
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$$ Need 1st highest & 2nd highest user details

[Lokesh Loki]

Hi Noorain and Kantilal,

Thanks for your valuable reply and the formula is working and also i got an
exact resolution.

Once again thank you for all.

Regards
Lokesh.M

On Fri, Aug 3, 2012 at 11:08 AM, Kantilal Badale
wrote:

> See Attached Sheet
>
> CA Kantilal Badale
>
>
>
> On Fri, Aug 3, 2012 at 9:32 AM, NOORAIN ANSARI 
> wrote:
>
>> Dear Lokesh,
>>
>> Please try it.
>>
>> =INDEX(C$3:C$5,MATCH(LARGE($D$3:$D$5,ROW(A1)),$D$3:$D$5,0))
>>
>> see attached sheet.
>>
>>
>> On Fri, Aug 3, 2012 at 8:17 AM, lokesh  wrote:
>>
>>>  Hi Experts,
>>>
>>> ** **
>>>
>>> Find the below table and I need 1st highest and 2nd highest user
>>> details in the below 2nd table. So could you please help me on.
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> User name
>>>
>>> Production
>>>
>>> timgings
>>>
>>> error
>>>
>>> quality
>>>
>>> productivity
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> Kumar P
>>>
>>> 250
>>>
>>> 5:20:30
>>>
>>> 6
>>>
>>> 98.95
>>>
>>> 120%
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> Harsha A V
>>>
>>> 375
>>>
>>> 4:30:10
>>>
>>> 5
>>>
>>> 97.25
>>>
>>> 100%
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> Santhosh
>>>
>>> 150
>>>
>>> 5:30:20
>>>
>>> 3
>>>
>>> 98.59
>>>
>>> 140%
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> *in the below table i need first highest & Second highest user details*
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> User name
>>>
>>> Production
>>>
>>> quality
>>>
>>> productivity
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> 1st highest
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> 2nd highest
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> 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
>>>
>>>
>>>
>>
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.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 po

$$Excel-Macros$$ manpower service

[vivek]

As per the new provision of reverse charge mechanism, 75% of service tax on 
supply of manpower service is to be paid by the service recipient if the 
service recipient is a company and the service provider is an individual, firm 
or AOP.

My question is whether security agencies service also falls in this category?

 

Thanks & Regards...

CA Vivek Jain, FCA, DISA (ICAI)

Vivek Shantilal Jain & Co.

Chartered Accountants

3010 Ram Kumar Arcade,

Chatribari Road, A T Road,

Guwahati-781001

0361-2603895,9435019908

save earth

 

-- 
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$$ just a wild thought regarding table in one cell

[सुनिता पौडेल]

I have tried to explain what I want it to be in comment box. I hope I am
able to explain.

Thanx

On Fri, Aug 3, 2012 at 12:09 PM, अनिल नारायण गवली
wrote:

> pl share a data with groups.
> Regards,
> Gawli Anil
>
> On Fri, Aug 3, 2012 at 11:52 AM, सुनिता पौडेल  wrote:
>
>> Dear all,
>>
>> Is there any possibility to create a small table where data can be put to
>> clarify the reason of the amount of one certain cell instead of inserting a
>> comment box? I mean if we can insert a table instead of only text like in
>> insert box.
>>
>> If it is possible then it will help me on my work as I need to comment on
>> the budget spend in particular head.
>>
>> Thank you,
>>
>> Sunita
>>
>> --
>> 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,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
>  --
> 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




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

$$Excel-Macros$$ Fw: Urgent Help needed

[francis vinod]

 Hello Experts,

Could you please provide me a solution on the below scenario.

Thanks & Regards,

Francis

- Forwarded Message -
From: francis vinod 
To: "excel-macros@googlegroups.com"  
Sent: Wednesday, 1 August 2012 6:54 PM
Subject: Help needed
 

Hello Team, 


Could you please help me in the below scenario.
I have two different reports from which I have to prepare a single report for 
reporting purpose.
In sheet 1 the reports contains tracking#, HW details etc. & and sheet 2 the 
report contains the values of the HW, tracking # etc

The report which I want should have the details of both Shee1 & Sheet 2 for 
which I have used the Vlookup formula and its fine.  The issue what I am facing 
is a single tracking # can have multiple line items and in the equipment report 
the equipments are split into seperate rows.  For eg, If a tracking # has 5 
different equipments with discreptions in 5 lineitems then when I use a VLookup 
formula it only shows the detail of equipment in 1st line.

So I want your help on this so that I get all the 5 equipment details in my 
report.  


Please find attached the excel file with an example.

If you could guide me it would be a great help and learning for me.

 
Thanks & Regards,
Francis

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




Scenario.xls
Description: MS-Excel spreadsheet