$$Excel-Macros$$ pls help me solve my query.

2012-08-03 Thread Kenil Gala
hi folks,i am having a query in getting external data,pls help me for the 
same.i have written my query in the excel sheet.

Thanks in adv,
Regards,

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




query for getting external data.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


$$Excel-Macros$$ just a wild thought regarding table in one cell

2012-08-03 Thread सुनिता पौडेल
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




Re: $$Excel-Macros$$ just a wild thought regarding table in one cell

2012-08-03 Thread अनिल नारायण गवली
pl share a data with groups.
Regards,
Gawli Anil

On Fri, Aug 3, 2012 at 11:52 AM, सुनिता पौडेल tosune...@gmail.com 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




Re: $$Excel-Macros$$ just a wild thought regarding table in one cell

2012-08-03 Thread सुनिता पौडेल
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, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:

 pl share a data with groups.
 Regards,
 Gawli Anil

 On Fri, Aug 3, 2012 at 11:52 AM, सुनिता पौडेल tosune...@gmail.com 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$$ manpower service

2012-08-03 Thread 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


image001.jpg

Re: $$Excel-Macros$$ Need 1st highest 2nd highest user details

2012-08-03 Thread 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
kantilal.bad...@gmail.comwrote:

 See Attached Sheet

 CA Kantilal Badale



 On Fri, Aug 3, 2012 at 9:32 AM, NOORAIN ANSARI 
 noorain.ans...@gmail.comwrote:

 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 lokeshsmg2...@gmail.com 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:// 
 http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/
 http:// 
 http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/http://accesssqclinic.blogspot.in/


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

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

2012-08-03 Thread 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 francis_vi...@yahoo.co.in
To: excel-macros@googlegroups.com 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$$ Plz Help Me

2012-08-03 Thread 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




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

2012-08-03 Thread 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




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

2012-08-03 Thread 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 
 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 

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

2012-08-03 Thread 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 dguille...@gmail.com
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 
francis_vi...@yahoo.co.in
To: excel-macros@googlegroups.com 
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$$ Trace Precedents and Trace Error

2012-08-03 Thread 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$$ Trace Precedents and Trace Error

2012-08-03 Thread 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 rajanverma1...@gmail.comwrote:

 * *

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

2012-08-03 Thread 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 rajanverma1...@gmail.com

  * *

 *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


Formula-auditing-Group-in-Excel-2007.jpg

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

2012-08-03 Thread 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 chilexcel...@gmail.com 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 rajanverma1...@gmail.com

  * *

 *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+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula 

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

2012-08-03 Thread 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 samde...@gmail.com

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

  * *

 *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$$ Marquee text in Powerpoint

2012-08-03 Thread 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

2012-08-03 Thread 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 chilexcel...@gmail.com 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 samde...@gmail.com

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

  * *

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

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

2012-08-03 Thread 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

2012-08-03 Thread 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 rajanverma1...@gmail.com
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
mailto:excel-macros%2bunsubscr...@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




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

2012-08-03 Thread 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 rajanverma1...@gmail.com

 

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 tel:%2B91%207838100659  [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
mailto:excel-macros%2bunsubscr...@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 

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

2012-08-03 Thread 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 samde...@gmail.com

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

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

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

  * *

 *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

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

2012-08-03 Thread Sam Mathai Chacko
:) ending this here. No comments

On Fri, Aug 3, 2012 at 10:27 PM, ChilExcel chilexcel...@gmail.com 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 samde...@gmail.com

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

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

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

  * *

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


 

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

2012-08-03 Thread noorain . ansari
Dear andrew,

Job posting is ban here.

Sent from BlackBerry® on Airtel

-Original Message-
From: Andrew Thomas andrew...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 3 Aug 2012 22:03:52 
To: andrew...@gmail.com
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

2012-08-03 Thread 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 samde...@gmail.com

 :) ending this here. No comments


 On Fri, Aug 3, 2012 at 10:27 PM, ChilExcel chilexcel...@gmail.com 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 samde...@gmail.com

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

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

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

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

  * *

 *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 

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

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

2012-08-03 Thread 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 andrew...@gmail.com 
 *Sender: * excel-macros@googlegroups.com 
 *Date: *Fri, 3 Aug 2012 22:03:52 +0530
 *To: *andrew...@gmail.com
 *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




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

2012-08-03 Thread 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 rajanverma1...@gmail.comwrote:

 * *

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

2012-08-03 Thread 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 jainayus...@gmail.com 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$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-03 Thread respuzy
Congrats Boss. Keep up the momentum
Sent from my BlackBerry® smartphone from Airtel Ghana

-Original Message-
From: Ayush Jain jainayus...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 3 Aug 2012 23:10:25 
To: excel-macrosexcel-macros@googlegroups.com
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

2012-08-03 Thread 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$$ Marquee text in Powerpoint

2012-08-03 Thread 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 rekha.siri2...@gmail.com 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

2012-08-03 Thread 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$$ Run-time error popup message

2012-08-03 Thread 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 lokeshsmg2...@gmail.com 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




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

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

2012-08-03 Thread Manoj Kumar
*Cong Noorain! Ji*

On Sat, Aug 4, 2012 at 4:16 AM, dguillett1 dguille...@gmail.com wrote:

   Good work!

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

  *From:* Ayush Jain jainayus...@gmail.com
 *Sent:* Friday, August 03, 2012 12:40 PM
 *To:* excel-macros 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




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

2012-08-03 Thread 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

2012-08-03 Thread 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

2012-08-03 Thread 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 rajanverma1...@gmail.comwrote:

 *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

2012-08-03 Thread अनिल नारायण गवली
congrats noorian ansari:)
Regards,
Gawli Anil

On Sat, Aug 4, 2012 at 10:38 AM, Kuldeep Singh naukrikuld...@gmail.comwrote:


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

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

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

2012-08-03 Thread 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, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:

 congrats noorian ansari:)
 Regards,
 Gawli Anil

 On Sat, Aug 4, 2012 at 10:38 AM, Kuldeep Singh naukrikuld...@gmail.comwrote:


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

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

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

2012-08-03 Thread 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 jainayus...@gmail.com 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