Pricing labels

**hecgroups** · 02-06-2012, 10:26 AM

Thank to Mr. Wieli, Mr. watersev & Mr. JapanDave for help me. i need a favor from you guys. kindly delete the attachments as it contain confidential information. If my management came to know about this file it may cause serious problem to me and i am sure i will lose my job.

Thanks for your efforts and your valuable help provided to me.

**watersev** · 02-06-2012, 10:55 AM

post #15 attachment deleted as requested

**hecgroups** · 02-06-2012, 11:42 AM

File is working perfect but still i have to check thoroughly. i will provide update after checking and marked solved if i have no issued.

Thanks to everyone one who help to resolved this issue. you guys make my life...

**hecgroups** · 02-07-2012, 09:57 AM

First of all i will thanks to you all who help me to setup this file. The file is working fine with other additional requirement but i am struck on below mentioned requirement.

This is my last request to finished up till issue.

It is possible to calculate all the members i.e. how many child, Employees & Spouses in age category by class wise and total premiums down in premium area.

Have a look on my new update file.

Sample file is attached for your easy reference.

**hecgroups** · 02-08-2012, 10:29 AM

Kindly find the file update file which need your help.

i have added one sheet (Loading Values) which need macros to add loading amount + in Template sheet need summary.

Need to calculate additional loading amount
Need summary of lives i.e. how many employee, Spouse & Child
Need calculation per member (Premium and loading) for Employee, Spouse& Child

Testing file is attached for your easy reference.

**JapanDave** · 02-08-2012, 11:46 AM

I am working on the file as we speak. I had a fair bit on at work today.

**hecgroups** · 02-08-2012, 12:12 PM

No problem take your time but just a request can it be finished tomorrow so that i can check wether it is working as per my requirement or not.

please use the updated file. Sorry for interruption.

Thanks for understanding my problem and help me.

**hecgroups** · 02-10-2012, 10:14 PM

Hai Mr. JapanDave,

Any luck for me.

**JapanDave** · 02-11-2012, 01:36 AM

I don't know what you want now? You have added sheets and different criteria. You will have to explain as clearly as possible what you want.

**hecgroups** · 02-11-2012, 10:31 AM

i am really sorry about changing the file. If we speak all together it will be mixup. so i will start one by one. OK.

i am very thankful to you that you have wrote VBA Macros to calculate the NRP based on nationality.

now i need help on counting no of employees at the same time it generate the report. i hope you understand this.

Sample file is attached for your reference.

If you help me up to set up this file i willbe very thankful to you.

**hecgroups** · 03-12-2012, 11:04 AM

Hello gMr. JapanDave,

i am having a problem with the file after changing the format of the cell. Can you help me to setup this issue.

Before the columns are:
Name 	Class	Age	Relation	Gender	Nationality



After new arrangement the columns are:
Name 	Gender	Class	Age	Relation	Nationality

After these changes the script is saying "Object variable or With block variable not set.

Copy of sheet is attached for your easy reference.