PDA

View Full Version : Pricing Tool



hecgroups
02-08-2012, 08:55 AM
Hello,

I am seeking help to have VBA macros to calculate additional loading from loading value sheet to Calculation Data sheet.

Sample sheet is attached for your easy reference.

Thanks in advance.

xld
02-08-2012, 09:20 AM
Give us a clue, explain your expected results, and how you get them.

hecgroups
02-08-2012, 09:30 AM
Thanks for quick response.

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.

hecgroups
02-08-2012, 10:56 AM
No one is their to help. please respond to my request.

hecgroups
03-14-2012, 12:24 PM
please delete the attachment as i have find the solution. Also tell me how to delete attachment and edit the topic to marked as solved

hecgroups
03-15-2012, 06:06 AM
still my file haven't delete please delete it i am unable to delete my attachment.

hecgroups
03-15-2012, 06:30 AM
anyone please respond to my request.

Paul_Hossler
03-15-2012, 05:07 PM
Don't bother about the file

Go to your first post

Thread Tools

You can just click the Solved button and [Perform Action]

Paul

hecgroups
03-16-2012, 01:27 AM
thanks for responding to my request but for me i did not get any dropdown menu