On monthly basis, we have to send a lot of monthly report to our clients. From master monthly report, we have to manual separate the master report to sub report and send to other batch of clients.

Master report and sub report is same layout. The different is recipient due to confidential data.

Our new proposal is tend to send the master report for all recipients. Our ideal master report is contains with macro, password and other formula. The authorize person only allowed to view authorize data in master report by using password provided.

Example –
Please refer to file attached. Kindly advice what kind of setting should we set.

Thanks