$$Excel-Macros$$ pls help me solve my query.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
*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
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
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
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
:) 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
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
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
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
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
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
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
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
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
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
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
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)
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
*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
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
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
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
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
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
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