Additional or discount % from other sheet
Hello Again,
Can any one help me to write a VBA macro to apply additional amount (%). I have one sheet named Loading Values which have % values in each cells. Based on class and age it will add the % amount.
For Excess Amount OR Discount:
Example. i want to give add amount for column NIL A5 i.e VIP class.
So the calculation will be like this C3:10 i will add 10% i.e. 50 +1.25% = 51.
Excess Amount OR Percentage
Example. i want to give add amount for column R5 (5%) i.e VIP class.
So the calculation will be like this C3:10 i will add 1.21 i.e. 50 +1.25% = 51.
Note: i can add both or any one or leave it blank.
Optical & Dental
But for dental and optical limit the calculation will be on class, Age & relation (Employee, Child & Spouse)
Thanks in advance.
Sample file is attached for your easy refference.
Lot of people have viewed my request but no one have replied. Comeon guys.
Have a couple of questions -
What do you mean by C3:10?So the calculation will be like this C3:10 i will add 10% i.e. 50 +1.25% = 51.
From where do you get the 50 in the above statement?
Where should the calculated values be input?
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
First of all thanks for respond to my request.
C3:C10 (Sorry Typing Mistake)
In first sheet (Calculation Data) C4
in loading sheet from B5:B9
it is little bit confusing but i am sure once you get the theme of my request then it will be easy for your to make VBA Macros.
I am still not able to understand as to where the calculated values - for e.g. 51 should be input?
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
we will go one by one OK.
I have 2 sheets named (Calculation Data &Loading Values) OK
on sheet Loading Values if i put any value in B5 or S5 (Any one) the result should be on sheet Calculation Data range C4:C10, D4:D10 & E3:E10.
I hope the above mentioned justification will make you understand what i want.
Kindly see the attached file for easy reference.
Kindly see the document i have attached on my request + online google share for your revision
i hope this will make your work easy for help.
Is their any solution for my request. please respond
Its pretty complicated and will need some good thought. I am a little caught up but will surely have something for you in the morning.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
carry on i have just asked in fact want to know can i get any result from this site or not. but as usual this site is always their for my help. Thanks for your support.
any news for me friend
Sorry to mark solved. To this topic their is nor button for editing the topic that is the reason i have left it like this.
How did you solve it?
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
By asking help on this site splitting my request.
Even it is longtime back i cannot remember also.PHP Code:Topic: http://www.excelforum.com/excel-programming/814297-correction-of-formula-simplify.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks