Hi Abhishek,
Attach your workbook, and lets see what you've got so far.
Regards - Dave.
Date: Mon, 14 Dec 2009 10:23:03 +0530
Subject: Re: $$Excel-Macros$$ A Simple VBA Query
From: abhishek....@gmail.com
To: excel-macros@googlegroups.com
Hi folks,
Any update ?
Regards,
On Fri, Dec 11, 2009 at 1:22 PM, Abhishek Jain <abhishek....@gmail.com> wrote:
Hi all,
Any help on this ?
Regards...Abhishek
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
_________________________________________________________________
Looking for a great date? Meet singles at ninemsn dating
http://clk.atdmt.com/NMN/go/150855801/direct/01/
--
----------------------------------------------------------------------------------
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
