$$Excel-Macros$$ Break Internal Links with in a Workbook-Excel
Dear Excel Gurus, I have a workbook with multiple Tabs which are interlinked. I want to break all the link at once. Is it possible with any shortcut / key stroke or Tricks ? Please help me out. Thanks in advance. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Compare two worksheet Trial Balance
Dear Excel gurus, Kindly check the trailing mail. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -Original Message- From: "Sandeep Kumar Chhajer" Sender: excel-macros@googlegroups.com Date: Sat, 5 Apr 2014 04:21:56 To: Excel Macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Compare two worksheet Trial Balance Dear Excel gurus, Every day I have to compare two identical formatted worksheet trial balance. I want macro to compare both the trial balance. Macro should work as below: It will give me an option to choose which two workbook contains (workbook only contains one worksheet containing trial balance). Both Work book contains data like below: TB 1st April G/L code. Amount 10005632. -100 20004128. 50 30008721. -50 40007214. 100 TB 2nd April G/L code. Amount 10005632. -100 10009841. -10 20004128. 60 30008721. -50 40007214. 100 I used to compare both the sheet with vlookup and prepare report like below Changes in TB G/L code. Amount. Mode Change 10009841. -10. New code 20004128.10. Change in amount (sorry for reason of confidentiality I can't share file with you all. I hope you all understand) If any one can help me out to automate the report I will be highly grateful. Thanks in advance. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Compare two worksheet Trial Balance
Dear Excel gurus, Every day I have to compare two identical formatted worksheet trial balance. I want macro to compare both the trial balance. Macro should work as below: It will give me an option to choose which two workbook contains (workbook only contains one worksheet containing trial balance). Both Work book contains data like below: TB 1st April G/L code. Amount 10005632. -100 20004128. 50 30008721. -50 40007214. 100 TB 2nd April G/L code. Amount 10005632. -100 10009841. -10 20004128. 60 30008721. -50 40007214. 100 I used to compare both the sheet with vlookup and prepare report like below Changes in TB G/L code. Amount. Mode Change 10009841. -10. New code 20004128.10. Change in amount (sorry for reason of confidentiality I can't share file with you all. I hope you all understand) If any one can help me out to automate the report I will be highly grateful. Thanks in advance. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Average Graph
Hi Praful, This happens everyday in stock market!! I think you should use moving average let's say average of every 5 days and plot everyday's moving average into graph! Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -Original Message- From: Prafull Jadhav Sender: excel-macros@googlegroups.com Date: Sun, 16 Mar 2014 09:04:39 To: excel-macros@googlegroups com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Average Graph Dear Abhishek Sir, Very good morning. If I now that ddaily frequency of cabs are between 50 to 80. Because of suddenly increased in cabs for few days this affects the overall average. I just want to show normal average.. Which excluding few days highest cabs. Regard, Prafull Jadhav. 9920553518 On 16-Mar-2014 12:26 AM, "Abhishek Jain" wrote: > Dear Prafull, > > As per example, a total of 1717 cars were handled in 2 weeks (14 days) > which means 123 (rounded off) is the correct average and it is not a "wrong > info". > > Now, the average for first week is 48 and for second week it is 197. If > you want, we can show week wise averages in the graph or you could > elaborate your need with more examples and/or sample data. > > If the values are suddenly increased in any week, the overall average is > going to increase as well. Just because it is high, does not mean its > wrong, or am I missing something here? > > Regards, > Abhishek > > > On Sat, Mar 15, 2014 at 11:42 PM, Prafull Jadhav > wrote: > >> Dear Abhishek Sir, >> thanks for reply . >> When we exclude the highest value from chart it average is less that is >> 44 and that is correct average . >> But When I show the this chart (included Highest Number ) to my boss , >> he will surprise that daily Average cabs coming is 123...and that is >> wrong... >> It gives wrong Nos to Management. >> >> >> >> Regards, >> Prafull Jadhav >> 9920553518 >> >> >> On 15 March 2014 20:44, ravinder negi wrote: >> >>> pls provide some example in excel with chart >>> >>> >>> On Saturday, March 15, 2014 8:12 AM, Abhishek Jain < >>> abhishek@gmail.com> wrote: >>> Does this make any sense? >>> >>> >>> On Sat, Mar 15, 2014 at 5:29 PM, Prafull Jadhav < >>> prafulltjad...@gmail.com> wrote: >>> >>> Dear All , >>> >>> Day before Yesterday I had gone for Interview for Data Analyst. They >>> asked me one question but i could not answer it . >>> >>> The Person who has taken my interview, asked me question on based on >>> Meru Cab where i was working earlier. >>> >>> Question was as below >>> >>> He asked me supposed Cabs are daily coming for Repair purpose in >>> workshop >>> it can be 50,60,70,40,65,35...Nos then what will be daily average the >>> cabs graphs. >>> Answer was very easy for above question. >>> then he asked supposed suddenly in few days cabs reached at workshop >>> with 150,500,200..Nos. >>> >>> How will i show graphs or Summary with stable average count. >>> if i include the Highest numbers in series then Average suddenly goes >>> up..and charts look like jumping at highest point. >>> >>> for avoid this ..which type of formula i have to apply here which show >>> stable Average or Graphs. >>> >>> Regards, >>> Prafull Jadhav >>> 9920553518 >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "
Re: $$Excel-Macros$$ calculate previous month dates using the given date
Can you give another example so that the logic get clear! Like what do you want if given date is 25th December 2013. 24th November to 23rd December? Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -Original Message- From: Sundarvelan N Sender: excel-macros@googlegroups.com Date: Tue, 11 Feb 2014 14:53:49 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ calculate previous month dates using the given date I need, 2 Jan to 1 Feb Thanks N.Sundarvelan 9600160150 On Tue, Feb 11, 2014 at 2:44 PM, DILIPandey wrote: > Hi Kathirvelan, > > You need dates between 2Jan to 1 Feb > or, 2 Jan to 3 Feb ? > > > > On Tue, Feb 11, 2014 at 12:44 PM, KATHIRVELAN N wrote: > >> Dear Friends, >> >> I need to calculate previous month dates using the given date >> >> Given Date : 03-Feb-2014 >> >> From Date Should Be : 02-Jan-2014 >> >> To Date : 01-Feb-2014 >> >> Thanks, >> Kathirvelan >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY, > mvp<https://mvp.microsoft.com/en-us/mvp/Dilip%20Kumar%20Pandey-4039851> >MBA,BCA,B.Com(Hons) > UAE +971 528225509 India +91 9810929744 > dilipan...@gmail.com, dilipan...@yahoo.com > > Skype: dilipandey | Gtalk: dilipandey | Yahoo: dilipandey > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed.
$$Excel-Macros$$ C002AB8CF
Those who are using BBM Channel check out this channel. Channel Pin C002AB8CF. :) Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ material Stock Inventory in Excel
Rupesh, Please use new thread for new queries, don't send new queries on others thread. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -Original Message- From: Rupesh Patil Sender: excel-macros@googlegroups.com Date: Fri, 20 Dec 2013 13:05:56 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ material Stock Inventory in Excel Hi expert I need some assistance, dose any buddy have application that used around 10 userForm and save data in excel around 450 columns for one record. thanks in advance On Fri, Dec 20, 2013 at 12:59 PM, Jocky Beta wrote: > Hi Sandeep, > > I want an excel sheet form which i can easily generate the reports like > Current Stock, Enters,Material Exits by months, material issue details, > material received details etc. > > Regards > > > On Fri, Dec 20, 2013 at 12:51 PM, Sandeep Kumar Chhajer < > chhajersand...@gmail.com> wrote: > >> Hi Jockey, >> >> Please specify your requirement. >> Thanks & Regards, >> Sandeep Kumar Chhajer >> Mumbai >> India >> >> Sent on my BlackBerry® from Vodafone >> -- >> *From: * Jocky Beta >> *Sender: * excel-macros@googlegroups.com >> *Date: *Fri, 20 Dec 2013 12:49:38 +0530 >> *To: * >> *ReplyTo: * excel-macros@googlegroups.com >> *Subject: *$$Excel-Macros$$ material Stock Inventory in Excel >> >> Hi All, >> >> Does anybody have material Stock Inventory sheet in Excel. if Yes kindly >> share >> >> *Rgerads* >> *Jocky* >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thr
Re: $$Excel-Macros$$ material Stock Inventory in Excel
Hi Jockey, Please specify your requirement. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -Original Message- From: Jocky Beta Sender: excel-macros@googlegroups.com Date: Fri, 20 Dec 2013 12:49:38 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ material Stock Inventory in Excel Hi All, Does anybody have material Stock Inventory sheet in Excel. if Yes kindly share *Rgerads* *Jocky* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ MS Excel
I possible please share a sample file. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -Original Message- From: "Soni.Rajender" Sender: excel-macros@googlegroups.com Date: Tue, 10 Dec 2013 23:25:40 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ MS Excel Dear Team I have a bulky database having details of Dealer, item code and Qty, I want to make a report that which dealer has not sold which item, please help, preferably using pivot table. dealerItemaa1ba2aa3ca4aa5da6 Regards, Rajender Soni -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Power Pivot
Dear All, I have excel 2013, I want to know what enhanced feature it has from 2010 and I also want to know about power pivot and its uses. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Pivot Table queries
Thanks Anup for your response. One more thing I want to ask is there any way I can use two column of Pivot table for any type of calculation (i.e. the calculation also become part of. Pivot table.) Suppose, with a data set I have derived with two column in a Pivot table, say one is sum and other being count, now I want to work with this two column i.e. Sum column / count column with in pivot table, Is it possible? Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -Original Message- From: Anoop K Sharma Sender: excel-macros@googlegroups.com Date: Wed, 30 Oct 2013 11:02:43 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Pivot Table queries Sandeep please insert required formula using pivot table formula. for this go to Options>formula>Calculated Field. Options Ribbon will populate once you select the pivot field and Calculated field will enable when you select any column field in pivot. On Wed, Oct 30, 2013 at 8:07 AM, Sandeep Kumar Chhajer < chhajersand...@gmail.com> wrote: > Hi, Excel gurus, > > I want to get a column in a pivot table which is comprising of division of > two data-source column. > > Thanks & Regards, > Sandeep Kumar Chhajer > Mumbai > India > > Sent on my BlackBerry® from Vodafone > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- Regards, Anoop Sr. Developer Facebook ID - https://www.facebook.com/anooop.k.sharma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribe
$$Excel-Macros$$ Pivot Table queries
Hi, Excel gurus, I want to get a column in a pivot table which is comprising of division of two data-source column. Thanks & Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry® from Vodafone -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Re: Recognizing Number format
Sorry for all mails sent to you today...actually my outlook is not working for
3 days and all mails were there in outbox.
Sorry for the inconvenience :(
All the issues regarding this thread are resolved.
Thanks once again.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Sandeep Chhajer"
Date: Tue, 8 Oct 2013 13:19:55
To:
Subject: Recognizing Number format
Dear Excel Gurus,
I have a peculiar problem. When I import data in excel from Tally it shows
me number as shown below
Balance
Debit
Credit
Balance
Aditya Birla Memorial Hospital
3049.00
3049.00
Aditya Enterprises
99521.00
101086.00
1565.00 Cr
Airways Corporation
39363.80 Dr
39363.80 Dr
Airways Surgical Pvt Ltd
361446.45 Dr
959168.00
1133676.00
186938.45 Dr
AL-SAMIYAH GROUP FOR MARKETING & INT. TRADE
791326.00
883606.25
92280.25 Cr
Al-Wafigroup for Marketing & Int'l Trade Co.
743036.00
754572.48
11536.48 Cr
When I check in format menu it shows me ""0.00" Cr" for NEGETAIVE value
and ""0.00" Dr" for POSITIVE value.
All I want to do is recognise the format with the help of macro and change
the value accordingly.
I have tried to develop a macro with my very lesser knowledge but it is
not working as value of variable "b" is not changing according to its
present (changing) location.
Please help.
My VBA Working
Sub format()
a = Range("e15").NumberFormat
' i want this "b" shall change value according to the new destination i.e.
' _want to make it as variable according to the new cell format.
b = ActiveCell.NumberFormat
Do
ActiveCell.Offset(1, 0).Select
If a = b Then
ActiveCell.Offset(0, 1).Select
ActiveCell.Formula = ActiveCell.Offset(0, -1) * -1
ActiveCell.Offset(0, -1).Select
Else
ActiveCell.Offset(0, 1).Select
ActiveCell.Formula = ActiveCell.Offset(0, -1) * 1
ActiveCell.Offset(0, -1).Select
End If
Loop Until ActiveCell.Offset(0, -4).Value = ""
End Sub
Thanks in advance.
Thank you
Regards
Sandeep Kumar Chhajer.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Identifying Excel number format
Excel gurus,
Any solution.
Sandeep.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Sandeep Chhajer
Date: Sat, 5 Oct 2013 15:14:11
To:
Subject: Re: $$Excel-Macros$$ Identifying Excel number format
PFA the original file. Hope it will work.
On 5 October 2013 13:00, ashish koul wrote:
> i can't see custom format
>
>
> On Sat, Oct 5, 2013 at 12:59 PM, Sandeep Kumar Chhajer <
> chhajersand...@gmail.com> wrote:
>
>> **
>> Dear Ashish,
>>
>> This is only original file, I have just cut down the number of entries to
>> certain extent as I am checking my code with lesser data.
>>
>> Sent on my BlackBerry® from Vodafone
>> --
>> *From: * ashish koul
>> *Sender: * excel-macros@googlegroups.com
>> *Date: *Sat, 5 Oct 2013 12:55:31 +0530
>> *To: *excel-macros
>> *ReplyTo: * excel-macros@googlegroups.com
>> *Subject: *Re: $$Excel-Macros$$ Identifying Excel number format
>>
>> can u share the orginal file
>>
>>
>> On Sat, Oct 5, 2013 at 12:53 PM, Sandeep Chhajer <
>> chhajersand...@gmail.com> wrote:
>>
>>> Dear Excel Gurus,
>>>
>>> I have facing a peculiar problem related to number format.
>>> When I export any ledger from tally I got result as bellow
>>>
>>>
>>>
>>>Aditya Birla Memorial Hospital 3049.00 3049.00Aditya Enterprises
>>> 99521.00 101086.00 *1565.00 Cr* Airways Corporation 39363.80 Dr *39363.80
>>> Dr* Airways Surgical Pvt Ltd 361446.45 Dr 959168.00 1133676.00 *186938.45
>>> Dr* AL-SAMIYAH GROUP FOR MARKETING & INT. TRADE 791326.00 883606.25
>>> *92280.25
>>> Cr* Al-Wafigroup for Marketing & Int'l Trade Co. 743036.00 754572.48
>>> *11536.48
>>> Cr*
>>>Now, the custom number format for negative number is *""0.00" Cr"* and
>>> for positive number is *""0.00" Dr". (I have also attached herewith the
>>> file for your reference.)*
>>> *
>>> *
>>> Again, I have tried to build a macro with my limited VBA knowledge but
>>> it is not working as variable "b" is not changing according to the current
>>> cursor location.
>>> I am pasting what i have tried.
>>>
>>>
>>> Sub format()
>>> a = Range("e15").NumberFormat
>>> ' *i want this "b" shall change value according to the new destination
>>> i.e.*
>>> *' _want to make it as variable according to the new cell format.*
>>> b = ActiveCell.NumberFormat
>>> Do
>>> ActiveCell.Offset(1, 0).Select
>>> If a = b Then
>>> ActiveCell.Offset(0, 1).Select
>>> ActiveCell.Formula = ActiveCell.Offset(0, -1) * -1
>>> ActiveCell.Offset(0, -1).Select
>>> Else
>>> ActiveCell.Offset(0, 1).Select
>>> ActiveCell.Formula = ActiveCell.Offset(0, -1) * 1
>>> ActiveCell.Offset(0, -1).Select
>>> End If
>>> Loop Until ActiveCell.Offset(0, -4).Value = ""
>>> End Sub
>>> *
>>> *
>>> Please Help me out.
>>>
>>> Thanks in advance.
>>>
>>>
>>> --
>>> Regards,
>>> Sandeep Kumar Chhajer.
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send e
Re: $$Excel-Macros$$ Identifying Excel number format
Dear Ashish,
This is only original file, I have just cut down the number of entries to
certain extent as I am checking my code with lesser data.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: ashish koul
Sender: excel-macros@googlegroups.com
Date: Sat, 5 Oct 2013 12:55:31
To: excel-macros
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Identifying Excel number format
can u share the orginal file
On Sat, Oct 5, 2013 at 12:53 PM, Sandeep Chhajer
wrote:
> Dear Excel Gurus,
>
> I have facing a peculiar problem related to number format.
> When I export any ledger from tally I got result as bellow
>
>
>
>Aditya Birla Memorial Hospital 3049.00 3049.00Aditya Enterprises
> 99521.00 101086.00 *1565.00 Cr* Airways Corporation 39363.80 Dr *39363.80
> Dr* Airways Surgical Pvt Ltd 361446.45 Dr 959168.00 1133676.00 *186938.45
> Dr* AL-SAMIYAH GROUP FOR MARKETING & INT. TRADE 791326.00 883606.25 *92280.25
> Cr* Al-Wafigroup for Marketing & Int'l Trade Co. 743036.00 754572.48
> *11536.48
> Cr*
>Now, the custom number format for negative number is *""0.00" Cr"* and
> for positive number is *""0.00" Dr". (I have also attached herewith the
> file for your reference.)*
> *
> *
> Again, I have tried to build a macro with my limited VBA knowledge but it
> is not working as variable "b" is not changing according to the current
> cursor location.
> I am pasting what i have tried.
>
>
> Sub format()
> a = Range("e15").NumberFormat
> ' *i want this "b" shall change value according to the new destination
> i.e.*
> *' _want to make it as variable according to the new cell format.*
> b = ActiveCell.NumberFormat
> Do
> ActiveCell.Offset(1, 0).Select
> If a = b Then
> ActiveCell.Offset(0, 1).Select
> ActiveCell.Formula = ActiveCell.Offset(0, -1) * -1
> ActiveCell.Offset(0, -1).Select
> Else
> ActiveCell.Offset(0, 1).Select
> ActiveCell.Formula = ActiveCell.Offset(0, -1) * 1
> ActiveCell.Offset(0, -1).Select
> End If
> Loop Until ActiveCell.Offset(0, -4).Value = ""
> End Sub
> *
> *
> Please Help me out.
>
> Thanks in advance.
>
>
> --
> Regards,
> Sandeep Kumar Chhajer.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*My Excel Blog <http://www.excelvbamacros.com/>*
Like Us on
Facebook<http://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897>
Join Us on Facebook <http://www.facebook.com/groups/163491717053198/>
P Before printing, think about the environment.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because yo
Re: $$Excel-Macros$$ EX-QUERY
Dear sridhar, I did not get you how leap year or non leap year affecting your result. Can you send us example. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: sridher sharma Sender: excel-macros@googlegroups.com Date: Mon, 9 Sep 2013 16:22:16 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ EX-QUERY yes i used this formula but it is stands valid in case of Non- leap years, Please give me a formula for leap years. On 9 September 2013 16:18, Ravi Kumar wrote: > Did u try this formula… > > ** ** > > ** ** > > Principle(1+rate/100)^month > > ** ** > > Like > > ** ** > > 500(1+5/100)^5 > > ** ** > > * * > > *Warm Regards,* > > *Ravi Kumar.* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *sridher sharma > *Sent:* Monday, September 09, 2013 4:08 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ EX-QUERY > > ** ** > > Dear member plz help me > > > > I am calculating compound interest on loan over a period where interest is > compounded either Monthly, Quarterly, Semi- Annually and Annually. > > But it is stands valid in case of Non- leap years. Please give me a > formulae for leap years. > > > > *Regards,* > > *SRIDHER SHARMA* > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send emai
