Re: $$Excel-Macros$$ excel function required to sum data on basis of criteria
try this SUMIFS(B:B,A:A,EOMONTH(MAX(A:A),-1)) On Sat, Jul 30, 2011 at 11:18 AM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: HI, Answer should come to 10 as per row no. 16 which is latest from the given data (ie May 2011 latest month from available data, and total of May 2011 is 10) But in the attavhed sheet answer is coming as 80 which is incorrect. Regards, Kaushik -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification
Thank you very much for the links. Most of them are just a normal reports like using the basic formulas. Is this is all about MIS Executive role to create the reports like this? Waiting for your reply - krrish On Sat, Jul 30, 2011 at 12:06 AM, XLS S xlst...@gmail.com wrote: Please find the below links http://www.citesales.com/ http://www.ksde.org/Default.aspx?tabid=2836 On Fri, Jul 29, 2011 at 9:05 PM, krishna mummina lovemekris...@gmail.comwrote: Thank you very much for the total input guys. Now, I just want to see some of the example reports and some excel sheets. Is there any site to find those reports etc..? Waiting for your kind reply - krrish On Wed, Jul 27, 2011 at 10:24 AM, Venkatesh Srinivas venkateshs@gmail.com wrote: I some how feel he need to know a bit of database basics... - Clean and organize the database before working on it... - Ensure to know the compatible formula- other features based on version and its disadvantages Regards Venkatesh +91 9841969353 On Wed, Jul 27, 2011 at 9:41 AM, XLS S xlst...@gmail.com wrote: Hey Please find below link http://en.wikipedia.org/wiki/Management_information_system On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.com wrote: Hi Group, My Name is krishna, Working as a Data Analyst from the last 3 years. My daily work includes working with excel, Creating General Reports, Pdf to Excel Conversion, Data Mining and Analyzing data by using Data Tools like, Filter, Formulas, Sorting etc.. But I got a mail from one of my friend, It is an Opening for MIS Executive. I just want to know the exact qualification needed for the job. I mean, what are the Tools i need to know, I know, Many of us are already well settled. So, I just want to know from you people, Thanking you and Waiting for your reply - Krrish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Venkatesh KS Phone: +91 98419 69353 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at
RE: $$Excel-Macros$$ excel function required to sum data on basis of criteria
Try this : =SUMIFS(B:B,A:A,DATE(YEAR(MAX(A:A)),MONTH(MAX(A:A)),0)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Saturday, July 30, 2011 11:35 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ excel function required to sum data on basis of criteria try this SUMIFS(B:B,A:A,EOMONTH(MAX(A:A),-1)) On Sat, Jul 30, 2011 at 11:18 AM, KAUSHIK SAVLA savla.kaus...@gmail.com wrote: HI, Answer should come to 10 as per row no. 16 which is latest from the given data (ie May 2011 latest month from available data, and total of May 2011 is 10) But in the attavhed sheet answer is coming as 80 which is incorrect. Regards, Kaushik -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul http://akoul.blogspot.com/ akoul.blogspot.com http://akoul.posterous.com/ http://akoul.wordpress.com/ akoul.wordpress.com My http://in.linkedin.com/pub/ashish-koul/10/400/830 Linkedin Profile P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification
Hi Kirish, Just go to Linked in and search MIS Executive and see what are all responsibilities and then you may get clear Picture what they are doing... *Best Regards,* *Venkat* *Chennai* On Sat, Jul 30, 2011 at 11:41 AM, krishna mummina lovemekris...@gmail.comwrote: Thank you very much for the links. Most of them are just a normal reports like using the basic formulas. Is this is all about MIS Executive role to create the reports like this? Waiting for your reply - krrish On Sat, Jul 30, 2011 at 12:06 AM, XLS S xlst...@gmail.com wrote: Please find the below links http://www.citesales.com/ http://www.ksde.org/Default.aspx?tabid=2836 On Fri, Jul 29, 2011 at 9:05 PM, krishna mummina lovemekris...@gmail.com wrote: Thank you very much for the total input guys. Now, I just want to see some of the example reports and some excel sheets. Is there any site to find those reports etc..? Waiting for your kind reply - krrish On Wed, Jul 27, 2011 at 10:24 AM, Venkatesh Srinivas venkateshs@gmail.com wrote: I some how feel he need to know a bit of database basics... - Clean and organize the database before working on it... - Ensure to know the compatible formula- other features based on version and its disadvantages Regards Venkatesh +91 9841969353 On Wed, Jul 27, 2011 at 9:41 AM, XLS S xlst...@gmail.com wrote: Hey Please find below link http://en.wikipedia.org/wiki/Management_information_system On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.com wrote: Hi Group, My Name is krishna, Working as a Data Analyst from the last 3 years. My daily work includes working with excel, Creating General Reports, Pdf to Excel Conversion, Data Mining and Analyzing data by using Data Tools like, Filter, Formulas, Sorting etc.. But I got a mail from one of my friend, It is an Opening for MIS Executive. I just want to know the exact qualification needed for the job. I mean, what are the Tools i need to know, I know, Many of us are already well settled. So, I just want to know from you people, Thanking you and Waiting for your reply - Krrish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Venkatesh KS Phone: +91 98419 69353 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :
Re: $$Excel-Macros$$ Excel /Adobe
Thnaks for reply On Fri, Jul 29, 2011 at 4:52 PM, XLS S xlst...@gmail.com wrote: No, because this is currently using Microsoft object On Fri, Jul 29, 2011 at 10:34 AM, Shrinivas Shevde shrinivas...@gmail.com wrote: Thanks .Can I just Copy paste as a simple Flash game I dont want to use Excel or Word Is it possible On Tue, Jul 26, 2011 at 6:34 PM, XLS S xlst...@gmail.com wrote: Hye.. just click Design mode then cut and paste ... for more information please find the attachment.. On Tue, Jul 26, 2011 at 1:27 PM, Shrinivas Shevde shrinivas...@gmail.com wrote: Thanks dear Please let me know how to do it On Tue, Jul 26, 2011 at 1:21 AM, XLS S xlst...@gmail.com wrote: Hey, Please find the attachment On Mon, Jul 25, 2011 at 2:52 PM, Shrinivas Shevde shrinivas...@gmail.com wrote: Dear Group Please Find attached file . Can any one help me to take out adobe file from excel and can play Adobe file seperately -- Shrini -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Shrini -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Shrini -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Shrini -- -- Some important links for excel users: 1.
Re: $$Excel-Macros$$ Date format
Thanks Venkat, the solution works for me. Ashish. On Jul 29, 7:14 pm, Venkat CV venkat1@gmail.com wrote: Hi , Try the Below you May get the output as required... =TEXT(A1,DD-MM-YY) *Best Regards,* *Venkat* *Chennai* * * On Fri, Jul 29, 2011 at 5:25 PM, Ashish Khandelwal 4everash...@gmail.comwrote: Hi, I have a date string in the format of dd-mm-. I want to change in the dd-mm-yy. The Output should be like 29-07-11 Please help. Thanks Regards, Ashish Khandelwal. -- --- --- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Date format
Hi Ashish. Welcome... *Best Regards,* *Venkat* *Chennai* * * On Sat, Jul 30, 2011 at 2:38 PM, Ashish 4everash...@gmail.com wrote: Thanks Venkat, the solution works for me. Ashish. On Jul 29, 7:14 pm, Venkat CV venkat1@gmail.com wrote: Hi , Try the Below you May get the output as required... =TEXT(A1,DD-MM-YY) *Best Regards,* *Venkat* *Chennai* * * On Fri, Jul 29, 2011 at 5:25 PM, Ashish Khandelwal 4everash...@gmail.comwrote: Hi, I have a date string in the format of dd-mm-. I want to change in the dd-mm-yy. The Output should be like 29-07-11 Please help. Thanks Regards, Ashish Khandelwal. -- --- --- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ difference between SQL Stored Procedures and SQL Querys
Dear All, What is the difference between SQL Stored Procedures and SQL Querys, Can any one Explain Clearly.. *Best Regards,* *Venkat* *Chennai* * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Poem - जोर से बोलो दम लगा के जय, Excel -Macro परिवार.
hi noorain , fine but my name s missing; thnks 2011/7/30 NOORAIN ANSARI noorain.ans...@gmail.com Dear Experts, I have written a poem on our group to complete 8000 Members in EXCEL-MACRO faimly. read and Enjoy... जहा रोज सैकड़ों Questions की होती है बौछार. फिर लगते है अति-उत्तम Answers की कतार. जहा Excel-Experts की है बहूत बड़ी भरमार. सदस्य संख्या जिसकी हो चुकी है 8 हज़ार. वो है यारों अपना Excel-Macro परिवार. होती है बरसात यहाँ Excel के फोर्मुलों की. स्वाद सभी लेते है Logic के रसगुल्लों की. Question चाहे हो टेढ़ा, चाहे हो आसान. यहाँ हर समस्या Excel की बनती है समाधान. Excel -Experts की Army जहा बैठी है तैयार. ताक़ में है कब आये कोई query रूपी शिकार. वो है यारों अपना Excel-Macro परिवार. धन्यवाद का Button जब करते है हम PUSH जी. सबसे पहले याद आते है अपने ग्रुप मैनेजर आयुष जी. Technique है जिनका सीधा-साधा,पर logic है बहूत deep जी. उस Excel -Expert का नाम है Pandey Mr dilip जी. जब चली है बात एक्सपर्ट की तो उन्हें भी देदे WISH . Group का दुलारा,सबके आँखों का तारा,Koul Mr आशीष. DAVE,PAUL,DANIEL,STD(V) इस ग्रुप के कोहिनूर है. MAHESH,HASEEB,VENKAT के different Logic सदा से मशहूर है. और जो एक्सपर्ट हर Query के answer खातिर रहते है बेकाबू. वो है अपने छैल-छबीले पुने वाले हंसमुख राजन बाबु. सुमधुर लगती है अगर इस ग्रुप की मुरली की तान. तो उसमे हर सदस्य का है यारों बहुमूल्य योगदान. ग्रुप के सारे सदस्यों की महिमा यु बनी रहे आपार. दुआ है दिन-दुनी रात चौगुनी हो इसका बिस्तार. जोर से बोलो दम लगा के जय Excel -Macro परिवार. -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Poem - जोर से बोलो दम लगा के जय, Excel -Macro परिवार.
Hi Noorain, SuperbPoem..Better if you Publish in English Every one can read Easily worldwide..all our group members.. *Best Regards,* *Venkat* *Chennai* * * 2011/7/30 XLS S xlst...@gmail.com Wonderful. मज़ा आ गया 2011/7/30 NOORAIN ANSARI noorain.ans...@gmail.com Dear Experts, I have written a poem on our group to complete 8000 Members in EXCEL-MACRO faimly. read and Enjoy... जहा रोज सैकड़ों Questions की होती है बौछार. फिर लगते है अति-उत्तम Answers की कतार. जहा Excel-Experts की है बहूत बड़ी भरमार. सदस्य संख्या जिसकी हो चुकी है 8 हज़ार. वो है यारों अपना Excel-Macro परिवार. होती है बरसात यहाँ Excel के फोर्मुलों की. स्वाद सभी लेते है Logic के रसगुल्लों की. Question चाहे हो टेढ़ा, चाहे हो आसान. यहाँ हर समस्या Excel की बनती है समाधान. Excel -Experts की Army जहा बैठी है तैयार. ताक़ में है कब आये कोई query रूपी शिकार. वो है यारों अपना Excel-Macro परिवार. धन्यवाद का Button जब करते है हम PUSH जी. सबसे पहले याद आते है अपने ग्रुप मैनेजर आयुष जी. Technique है जिनका सीधा-साधा,पर logic है बहूत deep जी. उस Excel -Expert का नाम है Pandey Mr dilip जी. जब चली है बात एक्सपर्ट की तो उन्हें भी देदे WISH . Group का दुलारा,सबके आँखों का तारा,Koul Mr आशीष. DAVE,PAUL,DANIEL,STD(V) इस ग्रुप के कोहिनूर है. MAHESH,HASEEB,VENKAT के different Logic सदा से मशहूर है. और जो एक्सपर्ट हर Query के answer खातिर रहते है बेकाबू. वो है अपने छैल-छबीले पुने वाले हंसमुख राजन बाबु. सुमधुर लगती है अगर इस ग्रुप की मुरली की तान. तो उसमे हर सदस्य का है यारों बहुमूल्य योगदान. ग्रुप के सारे सदस्यों की महिमा यु बनी रहे आपार. दुआ है दिन-दुनी रात चौगुनी हो इसका बिस्तार. जोर से बोलो दम लगा के जय Excel -Macro परिवार. -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Two major milestones : 8000 members and 1000+ posts
Congrates -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ National insurance calculator
Hi All, This is srinivas from Hyderabad working in a MNC company . I support UK clients here. My job is processing payroll for UK clients on Monthly Basis. Normally in UK we need to deduct National Insurance contribution from employee salary. There are different NI catogories and for each category I have attached the Percentages. Please find below the slabs for calculating national insuarence. 0-442 442-589 589-601 602-3337 3337-3540 3540 The slabs are same for all the NI categories But the Percentages and rebates varies from category to category. 1)In the attached sheet I will enter Pers No's of employees, Niablepay and NI category. Once I enter the Niable pay the Macro should divide the niable pay as per the above slabs. 2) in the second step it should calculate National insuarance Contribution for both Employee and Employer as applicable rates. I am attaching the complete information on the sheet. kindly request you help me on this ?? Please let us me know if you need any additional information. Many thanks in advance. Thanks and Regards, Srinivas.M -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Copy of NI_Calculator_2011-2012.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Poem - जोर से बोलो दम लगा के जय, Excel -Macro परिवार.
kamal hai , asey hi poem likhtey raho , aur hamey kush karte raho 2011/7/30 NOORAIN ANSARI noorain.ans...@gmail.com: Dear Experts, I have written a poem on our group to complete 8000 Members in EXCEL-MACRO faimly. read and Enjoy... जहा रोज सैकड़ों Questions की होती है बौछार. फिर लगते है अति-उत्तम Answers की कतार. जहा Excel-Experts की है बहूत बड़ी भरमार. सदस्य संख्या जिसकी हो चुकी है 8 हज़ार. वो है यारों अपना Excel-Macro परिवार. होती है बरसात यहाँ Excel के फोर्मुलों की. स्वाद सभी लेते है Logic के रसगुल्लों की. Question चाहे हो टेढ़ा, चाहे हो आसान. यहाँ हर समस्या Excel की बनती है समाधान. Excel -Experts की Army जहा बैठी है तैयार. ताक़ में है कब आये कोई query रूपी शिकार. वो है यारों अपना Excel-Macro परिवार. धन्यवाद का Button जब करते है हम PUSH जी. सबसे पहले याद आते है अपने ग्रुप मैनेजर आयुष जी. Technique है जिनका सीधा-साधा,पर logic है बहूत deep जी. उस Excel -Expert का नाम है Pandey Mr dilip जी. जब चली है बात एक्सपर्ट की तो उन्हें भी देदे WISH . Group का दुलारा,सबके आँखों का तारा,Koul Mr आशीष. DAVE,PAUL,DANIEL,STD(V) इस ग्रुप के कोहिनूर है. MAHESH,HASEEB,VENKAT के different Logic सदा से मशहूर है. और जो एक्सपर्ट हर Query के answer खातिर रहते है बेकाबू. वो है अपने छैल-छबीले पुने वाले हंसमुख राजन बाबु. सुमधुर लगती है अगर इस ग्रुप की मुरली की तान. तो उसमे हर सदस्य का है यारों बहुमूल्य योगदान. ग्रुप के सारे सदस्यों की महिमा यु बनी रहे आपार. दुआ है दिन-दुनी रात चौगुनी हो इसका बिस्तार. जोर से बोलो दम लगा के जय Excel -Macro परिवार. -- Thanks regards, Noorain Ansari http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ National insurance calculator
See the attached sheet.. Revert if any Queries : Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next Dim val1 As Variant If Target.Column = 2 Then Application.EnableEvents = False val1 = Target.Value If val1 = Then Target.Value = GoTo Err: End If If val1 443 Then Target.Value = 0-442 GoTo Err: ElseIf val1 442 And val1 590 Then Target.Value = 442-589 GoTo Err: ElseIf val1 588 And val1 603 Then Target.Value = 589-602 GoTo Err: ElseIf val1 601 And val1 3338 Then Target.Value = 602-3337 GoTo Err: ElseIf val1 3336 And val1 3541 Then Target.Value = 3337-3540 GoTo Err: ElseIf val1 3539 Then Target.Value = 3540 GoTo Err: End If Application.EnableEvents = True End If Err: Application.EnableEvents = True End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of srinivas m Sent: Saturday, July 30, 2011 4:34 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ National insurance calculator Hi All, This is srinivas from Hyderabad working in a MNC company . I support UK clients here. My job is processing payroll for UK clients on Monthly Basis. Normally in UK we need to deduct National Insurance contribution from employee salary. There are different NI catogories and for each category I have attached the Percentages. Please find below the slabs for calculating national insuarence. 0-442 442-589 589-601 602-3337 3337-3540 3540 The slabs are same for all the NI categories But the Percentages and rebates varies from category to category. 1)In the attached sheet I will enter Pers No's of employees, Niablepay and NI category. Once I enter the Niable pay the Macro should divide the niable pay as per the above slabs. 2) in the second step it should calculate National insuarance Contribution for both Employee and Employer as applicable rates. I am attaching the complete information on the sheet. kindly request you help me on this ?? Please let us me know if you need any additional information. Many thanks in advance. Thanks and Regards, Srinivas.M -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Copy of Copy of NI_Calculator_2011-2012.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Poem - जोर से बोलो दम लगा के जय, Excel -Macro परिवार.
Thanks Noorain ! Excellent poem everytime :) 2011/7/30 Jattin Agarwal jatti...@gmail.com kamal hai , asey hi poem likhtey raho , aur hamey kush karte raho 2011/7/30 NOORAIN ANSARI noorain.ans...@gmail.com: Dear Experts, I have written a poem on our group to complete 8000 Members in EXCEL-MACRO faimly. read and Enjoy... जहा रोज सैकड़ों Questions की होती है बौछार. फिर लगते है अति-उत्तम Answers की कतार. जहा Excel-Experts की है बहूत बड़ी भरमार. सदस्य संख्या जिसकी हो चुकी है 8 हज़ार. वो है यारों अपना Excel-Macro परिवार. होती है बरसात यहाँ Excel के फोर्मुलों की. स्वाद सभी लेते है Logic के रसगुल्लों की. Question चाहे हो टेढ़ा, चाहे हो आसान. यहाँ हर समस्या Excel की बनती है समाधान. Excel -Experts की Army जहा बैठी है तैयार. ताक़ में है कब आये कोई query रूपी शिकार. वो है यारों अपना Excel-Macro परिवार. धन्यवाद का Button जब करते है हम PUSH जी. सबसे पहले याद आते है अपने ग्रुप मैनेजर आयुष जी. Technique है जिनका सीधा-साधा,पर logic है बहूत deep जी. उस Excel -Expert का नाम है Pandey Mr dilip जी. जब चली है बात एक्सपर्ट की तो उन्हें भी देदे WISH . Group का दुलारा,सबके आँखों का तारा,Koul Mr आशीष. DAVE,PAUL,DANIEL,STD(V) इस ग्रुप के कोहिनूर है. MAHESH,HASEEB,VENKAT के different Logic सदा से मशहूर है. और जो एक्सपर्ट हर Query के answer खातिर रहते है बेकाबू. वो है अपने छैल-छबीले पुने वाले हंसमुख राजन बाबु. सुमधुर लगती है अगर इस ग्रुप की मुरली की तान. तो उसमे हर सदस्य का है यारों बहुमूल्य योगदान. ग्रुप के सारे सदस्यों की महिमा यु बनी रहे आपार. दुआ है दिन-दुनी रात चौगुनी हो इसका बिस्तार. जोर से बोलो दम लगा के जय Excel -Macro परिवार. -- Thanks regards, Noorain Ansari http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Best regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ difference between SQL Stored Procedures and SQL Querys
stored proceure compiles only once and stores in database managemant system so it is optimized for best performance while sql query compiles every time and executes using dbms driver so its performance decreses On Sat, Jul 30, 2011 at 2:54 PM, Venkat CV venkat1@gmail.com wrote: Dear All, What is the difference between SQL Stored Procedures and SQL Querys, Can any one Explain Clearly.. *Best Regards,* *Venkat* *Chennai* * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Poem - जोर से बोलो दम लगा के जय, Excel -Macro परिवार.
Hello, Noorain, I am really sad not to understand the meaning of your poem (is it Hindi ? I failed to learn it a few years ago) I shall really enjoy to get a translation from it. If you have time enough to do it. Regards. Daniel On 30 juil, 04:20, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Experts, I have written a poem on our group to complete 8000 Members in EXCEL-MACRO faimly. read and Enjoy... जहा रोज सैकड़ों Questions की होती है बौछार. फिर लगते है अति-उत्तम Answers की कतार. जहा Excel-Experts की है बहूत बड़ी भरमार. सदस्य संख्या जिसकी हो चुकी है 8 हज़ार. वो है यारों अपना Excel-Macro परिवार. होती है बरसात यहाँ Excel के फोर्मुलों की. स्वाद सभी लेते है Logic के रसगुल्लों की. Question चाहे हो टेढ़ा, चाहे हो आसान. यहाँ हर समस्या Excel की बनती है समाधान. Excel -Experts की Army जहा बैठी है तैयार. ताक़ में है कब आये कोई query रूपी शिकार. वो है यारों अपना Excel-Macro परिवार. धन्यवाद का Button जब करते है हम PUSH जी. सबसे पहले याद आते है अपने ग्रुप मैनेजर आयुष जी. Technique है जिनका सीधा-साधा,पर logic है बहूत deep जी. उस Excel -Expert का नाम है Pandey Mr dilip जी. जब चली है बात एक्सपर्ट की तो उन्हें भी देदे WISH . Group का दुलारा,सबके आँखों का तारा,Koul Mr आशीष. DAVE,PAUL,DANIEL,STD(V) इस ग्रुप के कोहिनूर है. MAHESH,HASEEB,VENKAT के different Logic सदा से मशहूर है. और जो एक्सपर्ट हर Query के answer खातिर रहते है बेकाबू. वो है अपने छैल-छबीले पुने वाले हंसमुख राजन बाबु. सुमधुर लगती है अगर इस ग्रुप की मुरली की तान. तो उसमे हर सदस्य का है यारों बहुमूल्य योगदान. ग्रुप के सारे सदस्यों की महिमा यु बनी रहे आपार. दुआ है दिन-दुनी रात चौगुनी हो इसका बिस्तार. जोर से बोलो दम लगा के जय Excel -Macro परिवार. -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Poem - जोर से बोलो दम लगा के जय, Excel -Macro परिवार.
Hello Daniel, I tried to use google translate to convert the same into english. Few lines converted very well but the meaning may have changed in few lines. Noorain, Can you please fix the lines where the intended meaning is changed. Thanks. Where is the daily barrage of hundreds Questions. Then start over - the line of Best Answers. Where the very large glut of Excel-Experts. It's the 8 thousand members. Is that your Excel-Macro family of boys. Is the rain of Excel formulas here. Taste of Logic Rsgullon of all charges. Question is whether sloping, easy to get it. Here is the solution to every problem created in Excel. Excel-Experts to prepare the Army is sitting where. A query came when running the game at recess. Is that your Excel-Macro family of boys. Thanks to the Button when we live PUSH. First of all I miss your Group Manager AYUSH law. Technique's that simple - but very deep in-law's logic. Is the name of the Excel-Expert Pandey Mr dilip law. Is left to the experts, they also Dede WISH. Group's pet, the apple of everyone's eyes, Koul Mr Ashish. DAVE, PAUL, DANIEL, STD (V) is the Kohinoor Group. MAHESH, HASEEB, VENKAT always known the different Logic. And the expert's answer for every Query wild living. That's my Cutie - The Jolly Rajan Babu Cbile Res. This group seems saccharine tone of Murali. So it is each member contributes valuable guys. Group Apar all members continue to glorify war. Dua's Day - that the ground gained by leaps and bounds. Come on speak up Excel-Macro family of the Glory. Regards Ayush Jain Group Manager 2011/7/30 daniel dcolarde...@gmail.com Hello, Noorain, I am really sad not to understand the meaning of your poem (is it Hindi ? I failed to learn it a few years ago) I shall really enjoy to get a translation from it. If you have time enough to do it. Regards. Daniel On 30 juil, 04:20, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Experts, I have written a poem on our group to complete 8000 Members in EXCEL-MACRO faimly. read and Enjoy... जहा रोज सैकड़ों Questions की होती है बौछार. फिर लगते है अति-उत्तम Answers की कतार. जहा Excel-Experts की है बहूत बड़ी भरमार. सदस्य संख्या जिसकी हो चुकी है 8 हज़ार. वो है यारों अपना Excel-Macro परिवार. होती है बरसात यहाँ Excel के फोर्मुलों की. स्वाद सभी लेते है Logic के रसगुल्लों की. Question चाहे हो टेढ़ा, चाहे हो आसान. यहाँ हर समस्या Excel की बनती है समाधान. Excel -Experts की Army जहा बैठी है तैयार. ताक़ में है कब आये कोई query रूपी शिकार. वो है यारों अपना Excel-Macro परिवार. धन्यवाद का Button जब करते है हम PUSH जी. सबसे पहले याद आते है अपने ग्रुप मैनेजर आयुष जी. Technique है जिनका सीधा-साधा,पर logic है बहूत deep जी. उस Excel -Expert का नाम है Pandey Mr dilip जी. जब चली है बात एक्सपर्ट की तो उन्हें भी देदे WISH . Group का दुलारा,सबके आँखों का तारा,Koul Mr आशीष. DAVE,PAUL,DANIEL,STD(V) इस ग्रुप के कोहिनूर है. MAHESH,HASEEB,VENKAT के different Logic सदा से मशहूर है. और जो एक्सपर्ट हर Query के answer खातिर रहते है बेकाबू. वो है अपने छैल-छबीले पुने वाले हंसमुख राजन बाबु. सुमधुर लगती है अगर इस ग्रुप की मुरली की तान. तो उसमे हर सदस्य का है यारों बहुमूल्य योगदान. ग्रुप के सारे सदस्यों की महिमा यु बनी रहे आपार. दुआ है दिन-दुनी रात चौगुनी हो इसका बिस्तार. जोर से बोलो दम लगा के जय Excel -Macro परिवार. -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Best regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Help needed to comine VBA modules
Dear Rajanverma, Thanks for your help aju v chacko On Sat, Jul 30, 2011 at 6:33 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Also add this Function to Remove Special Character From Sheet name ,Because if the Special Character include in the string it will not change the Sheet name, See the attached file.. Public Function SheetName(Shname As String) As String Dim Cod As Integer Dim ShN As String For i = 1 To Len(Shname) Cod = Asc(Mid(Shname, i, 1)) If (Cod 64 And Cod 91) Or (Cod 96 And Cod 123) Or (Cod 79 And Cod 90) Then ShN = ShN Mid(Shname, i, 1) End If Next SheetName = ShN End Function -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Daniel Sent: Saturday, July 30, 2011 6:12 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Help needed to comine VBA modules Here is my test file. -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de aju chacko Envoyé : samedi 30 juillet 2011 05:33 À : excel-macros@googlegroups.com Objet : Re: $$Excel-Macros$$ Help needed to comine VBA modules Dear daniel, Thanks for ur kind reply,But when i pasted this module into the module' analysis',the following line showing compilation error(red colour).error-(sub or function not defined). Set rg = Sheets(ANALYSIS).PivotTables(1).DataBodyRange If Intersect(Target, rg) Is Nothing Then Exit Sub If Target.Value Then End If Kindly help Aju v chacko On 7/29/11, Daniel dcolarde...@free.fr wrote: Paste the macro below in the ANALYSIS module : Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim rg As Range Set rg = Sheets(ANALYSIS).PivotTables(1).DataBodyRange If Intersect(Target, rg) Is Nothing Then Exit Sub Cancel = True If Target.Value Then Target.ShowDetail = True ActiveSheet.Name = Target.Offset(, -1).Value End If End Sub Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de aju chacko Envoyé : vendredi 29 juillet 2011 16:25 À : excel macro forum Objet : Fwd: $$Excel-Macros$$ Help needed to comine VBA modules Dear daniel, As u can see in w.sheet analysis contain a pivot table created by the macro,There are two columns one is row labels (Final B Mr/S Batch Apex..) other sum of value field which is a actually a sum of numeric field,It is possible to Drill down specific numeric filed,by double clicking on it,Then a new sheet will be created with Drilled down value,But the sheet name will be 'sheet2,sheet3...'.Instead of such w.sheet name i want the name of w.sheet being created to be taken from respective row lable' field of the numeric value on which i clicked.for ex:if clicked on value '403',the name of the sheet should be Wound B.Hope it is clear Thanking you in advance for the help. Regards aju -- Forwarded message -- From: aju chacko ajuvcha...@gmail.com Date: Thu, Jul 28, 2011 at 9:40 AM Subject: Fwd: $$Excel-Macros$$ Help needed to comine VBA modules To: excel-macros@googlegroups.com -- Forwarded message -- From: aju chacko ajuvcha...@gmail.com Date: Wed, 27 Jul 2011 11:37:44 +0100 Subject: $$Excel-Macros$$ Help to create project from the Vba modules To: excel macro forum excel-macros@googlegroups.com Hi Friends, i wanted to drill down the pivotable(in w.sheet ANALYSIS) in such way that the Name of new worksheet being created during drill down being taken form the row label (Final b,Apex..etc) of pivot table on which I clicked.Since I am novice to excel vba,i am not competent enough to solve this issue.please see the attachement Kindly help. With regards aju v chacko ajuvcha...@gmail.com -- -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link
RE: $$Excel-Macros$$ Re: Poem - जोर से बोलो दम लगा के जय, Excel -Macro परिवार.
Hello, Ayush, Thanks for the translation. It’s a quite nice poem, although, sadly, the essence of a poem cannot be translated. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Ayush Jain Envoyé : samedi 30 juillet 2011 16:54 À : excel-macros@googlegroups.com Objet : Re: $$Excel-Macros$$ Re: Poem - जोर से बोलो दम लगा के जय, Excel -Macro परिवार. Hello Daniel, I tried to use google translate to convert the same into english. Few lines converted very well but the meaning may have changed in few lines. Noorain, Can you please fix the lines where the intended meaning is changed. Thanks. Where is the daily barrage of hundreds Questions. Then start over - the line of Best Answers. Where the very large glut of Excel-Experts. It's the 8 thousand members. Is that your Excel-Macro family of boys. Is the rain of Excel formulas here. Taste of Logic Rsgullon of all charges. Question is whether sloping, easy to get it. Here is the solution to every problem created in Excel. Excel-Experts to prepare the Army is sitting where. A query came when running the game at recess. Is that your Excel-Macro family of boys. Thanks to the Button when we live PUSH. First of all I miss your Group Manager AYUSH law. Technique's that simple - but very deep in-law's logic. Is the name of the Excel-Expert Pandey Mr dilip law. Is left to the experts, they also Dede WISH. Group's pet, the apple of everyone's eyes, Koul Mr Ashish. DAVE, PAUL, DANIEL, STD (V) is the Kohinoor Group. MAHESH, HASEEB, VENKAT always known the different Logic. And the expert's answer for every Query wild living. That's my Cutie - The Jolly Rajan Babu Cbile Res. This group seems saccharine tone of Murali. So it is each member contributes valuable guys. Group Apar all members continue to glorify war. Dua's Day - that the ground gained by leaps and bounds. Come on speak up Excel-Macro family of the Glory. Regards Ayush Jain Group Manager 2011/7/30 daniel dcolarde...@gmail.com Hello, Noorain, I am really sad not to understand the meaning of your poem (is it Hindi ? I failed to learn it a few years ago) I shall really enjoy to get a translation from it. If you have time enough to do it. Regards. Daniel On 30 juil, 04:20, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Experts, I have written a poem on our group to complete 8000 Members in EXCEL-MACRO faimly. read and Enjoy... जहा रोज सैकड़ों Questions की होती है बौछार. फिर लगते है अति-उत्तम Answers की कतार. जहा Excel-Experts की है बहूत बड़ी भरमार. सदस्य संख्या जिसकी हो चुकी है 8 हज़ार. वो है यारों अपना Excel-Macro परिवार. होती है बरसात यहाँ Excel के फोर्मुलों की. स्वाद सभी लेते है Logic के रसगुल्लों की. Question चाहे हो टेढ़ा, चाहे हो आसान. यहाँ हर समस्या Excel की बनती है समाधान. Excel -Experts की Army जहा बैठी है तैयार. ताक़ में है कब आये कोई query रूपी शिकार. वो है यारों अपना Excel-Macro परिवार. धन्यवाद का Button जब करते है हम PUSH जी. सबसे पहले याद आते है अपने ग्रुप मैनेजर आयुष जी. Technique है जिनका सीधा-साधा,पर logic है बहूत deep जी. उस Excel -Expert का नाम है Pandey Mr dilip जी. जब चली है बात एक्सपर्ट की तो उन्हें भी देदे WISH . Group का दुलारा,सबके आँखों का तारा,Koul Mr आशीष. DAVE,PAUL,DANIEL,STD(V) इस ग्रुप के कोहिनूर है. MAHESH,HASEEB,VENKAT के different Logic सदा से मशहूर है. और जो एक्सपर्ट हर Query के answer खातिर रहते है बेकाबू. वो है अपने छैल-छबीले पुने वाले हंसमुख राजन बाबु. सुमधुर लगती है अगर इस ग्रुप की मुरली की तान. तो उसमे हर सदस्य का है यारों बहुमूल्य योगदान. ग्रुप के सारे सदस्यों की महिमा यु बनी रहे आपार. दुआ है दिन-दुनी रात चौगुनी हो इसका बिस्तार. जोर से बोलो दम लगा के जय Excel -Macro परिवार. -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Best regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn
Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification
vijaykumar and venkat thank you very much for your valuable input. On Sat, Jul 30, 2011 at 8:23 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Dear Krishna, The profile of MIS Executive changes with the type organisation.If it is a small organisation MIS Executive role would be to prepare normal reports like the work you do.If it is a big and reputed organisation your role in addition to normal report preparation would be to do fianacial modelling or creating financial model which would help the management in its decision making process. For more information for using excel in financial modelling u can refer to the website www.exinfm.com. Regards, Vijaykumar On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.comwrote: Hi Group, My Name is krishna, Working as a Data Analyst from the last 3 years. My daily work includes working with excel, Creating General Reports, Pdf to Excel Conversion, Data Mining and Analyzing data by using Data Tools like, Filter, Formulas, Sorting etc.. But I got a mail from one of my friend, It is an Opening for MIS Executive. I just want to know the exact qualification needed for the job. I mean, what are the Tools i need to know, I know, Many of us are already well settled. So, I just want to know from you people, Thanking you and Waiting for your reply - Krrish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- P.VIJAY KUMAR -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ urgent macro required pls
hello i have 15 files in one folder. i need to combine two sheets called as maps and shipment of all the 15 files into one consolidated file with 2 sheets( with respective data). Structure and columns are same in sheets for all the files. Can you pls give a macro.. also can you please let m e know on how to run the macro i never ran it.. like do i have to open the first spreadsheet while running macro thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Formula or macro to find a word that is all capitlaized
Exzcellent guys. Amazing. Thanks. On Jul 28, 8:18 am, XLS S xlst...@gmail.com wrote: Hey Ranjan qcan want if cell contain any 3 Capital letter then color hole cell.but your solution color only first 3 letter ... On Thu, Jul 28, 2011 at 5:32 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hope it will Help you Sub HighLight() Application.ScreenUpdating = False On Error Resume Next Dim cell As Range Dim rng As Range Dim st As String Dim loc As Integer Dim n as string st = Set rng = ActiveSheet.UsedRange For Each cell In rng If cell.Value Then st = st cell.Value End If Next For i = 1 To Len(st) n = Mid(st, i, 1) Mid(st, i + 1, 1) Mid(st, i + 2, 1) If Asc(Mid(n, 1, 1)) 64 And Asc(Mid(n, 1, 1)) 91 And Asc(Mid(n, 2, 1)) 64 And Asc(Mid(n, 2, 1)) 91 And Asc(Mid(n, 3, 1)) 64 And Asc(Mid(n, 3, 1)) 91 Then Cells.Find(What:=n, After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate loc = WorksheetFunction.Find(n, ActiveCell.Value, 1) ActiveCell.Characters(loc, 3).Font.ColorIndex = 26 ActiveCell.Characters(loc, 3).Font.Bold = True i = i + 3 End If Next Application.ScreenUpdating = True End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of qcan Sent: Thursday, July 28, 2011 3:40 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Formula or macro to find a word that is all capitlaized Hi, Can anyone help me with some sort of formula or Macro that would identify any word (minmum 3 letters) that is all in caps. I would like whatever is found to be highlighted in yellow. Thanks. -- ---- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- .- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ urgent help needed.
Try this see if it helps On Sun, Jul 31, 2011 at 12:18 AM, Sara Lee lee.sar...@gmail.com wrote: hello i need to combine multiple excel files(15) into one excel file. Each file has 2 sheets... R and S and data from both needs to consolidated into respective sheets. .. so i need a macro which can give one file with two sheets that consolidate data from all the files... All the files have same structure and columns. Also please let me know step by step on how to run the macro and do i have to run it from the first file Thanks much.. this is urgent -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel NEW merge from different workbooks.xlsm Description: Binary data
$$Excel-Macros$$ Remove HyperLink without Macro
Dear All, Try this 1. In a blank cell, enter the number 1. 2. Select the cell and press *Ctrl+C*. 3. Hold down the *Ctrl* key as you click each hyperlink you want to remove. 4. Right Click and Choose Paste Special from 5. Select the Multiply radio button (In Operations). 6. Click OK. All the hyperlinks are removed, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel