HI EVERYBODY CAN YOU SUGGEST ME ANY BOOK ON EXCEL FORMULAS
OR SEND ME ANY POWER POINT PRESENTATION FILE REGARDS VIKAS On Tue, Dec 8, 2009 at 8:31 PM, Abhishek Jain <abhishek....@gmail.com> wrote: > > Hi all, > > First of all I am very sorry to bother this group so much. > > I am trying to write a code but I don't know any thing about coding (all > right, you can laugh on this). I prefer searching Internet > for codes/solutions and then to use it. Recording Macros, Excel Help are my > other helping hands. > > Here is my query - > > There are 03 people - Name1, Name2 and Name3. These 03 people shares expenses > done for a cause that is bearable by at least 02 of them. Example - If Name1 > spends Rs. 300/- for a Dinner, it will be divided between atleast 02 people > (Name1 and Name2 or Name2 and Name3) or between all of them and the cost > would be divided between those who ate the dinner. (Expenses done by any of > these 03 which are not spent for atleast 02 of them, are disregarded). > > I have prepared all necessary spreadsheet, forms, etc. to record these > transactions and they are working pretty fine. Now these transactions get > recorded for a month and at the end of the month all 03 adjust and settle the > differential amount. It almost never happens that all of them spend the exact > amount equal to their share, hence, these are the common scenarios - > > > At the end of the month, there would be atleast one payer who will pay > > certain amount to either 1 person or 2. > > There can be 02 payers who would pay to one person. > > Here is the example of the summary at the end of the month - > A B > C D > 1 Name of user Expenses borne > Share Stands > 2 Name1 2000/- > 1500/- +500/- > 3 Name2 1000/- > 2100/- -1100/- > 4 Name3 1600/- > 1000/- +600/- > 5 > 6 Total - 4600/- > 4600/- > > In this situation - Name2 will pay Rs. 500/- to Name1 and Rs. 600/- to Name3. > At the end of the month I want a Message Box stating this - > > Name2 has to Pay Rs. 500/- to Name1. > Name2 has to pay Rs. 600/- to Name3. > > then an input box for payments entry and updation in the workbook- I will do > coding for this myself. > > Suppose Name2 has paid Rs. 400/- to Name1 and Rs. 200/- to Name3. So the next > time the Message box should say - > > Name2 has to Pay Rs. 100/- to Name1. > Name2 has to pay Rs. 500/- to Name3. > > This will continue till the amount is settled. I tried and put some if > conditions, it is working for the scene of 02 payers and 01 payee but not in > case to 01 payer and 02 payees. I have also not wrote it further to adjust > amount till it settles. All I want is a code to prompt this Msgbox given the > conditions/scenerios above. > > I am again sorry for being so long but this will help me to learn to write > codes like this. > > > Thanks in advance. > > Best regards, > > Abhishek Jain > > > > > > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe