Medical Health Quotation Generate

Hello,

I am seeking help to generate health quotation for 4 classes i.e. VIP,A, B & C. Below is the detail explanation. I have attached a sample file but remove the text due to company policy secrets. Kindly keep the same page setup which will help me a lot.

Generate Quotation:

1. Script should check the number of member are exists for which class in NRP sheet. Quotation will be generated based on this criteria/theme.

a. For example if I have values in I28:I34 if should generate quotation for Class VIP class only.
b. For example if I have values in L28:L34 if should generate quotation for Class A class only.
c. For example if I have values in O28:O34 if should generate quotation for Class B class only.
d. For example if I have values in R28:R34 if should generate quotation for Class C class only.

2. Explanation of generating quotation.
a. If any of the above examples is true then it should copy master quotation with the classes whose members are exits and delete the other columns which is not needed.
b. Classes should be started from right to left i.e. From column M.
c. Rest of the rows and columns should be merge to keep the same page setup and display data properly.

i. Example if the quotation is generated for classes VIP and C. The C class should be displayed in column M whereas VIP class should be displayed in column L and A138: K183 should be merge.

3. Number of members & Premiums calculation:-
a. Copy numbers of members from NRP sheet i.e. I28:T34 to quotation sheet i.e. B223:M229 while generating quotation.
i. Based on class and relation it should copy the number of members. Example: Class VIP = age 0-24 = Child = 5
b. Copy premiums from NRP sheet i.e. I39:T45 to quotation sheet i.e. B251:M257 while generating quotation.

I am attaching 2 different sample a sheets to get more clarification. After generating the quotation for VIP class how it looks and for classes VIP & B how it looks.

I hope the above mentioned details is enough for you guys to help me.

Waiting for somebody to help me...

hi hecgroups, please check attachment, run code "test"

Colouring in Memebrs Number table and Premiums is done by conditional format.