Print to PDF in VBA

[visheshkotha]

ED REVIEW 3.xlsm

drive.google.com

I have an excel that calculates business position for 481 branch locations. There are certain number of branches under each Regional Office (RO/RO Name). User can select the branch by entering the DP Code of the branch or by selecting from drop down list. Data is being fetched from 24 different sheets in the main profile sheet. Branch Manager Name, RO Name is being fetched from HRM Sheet. I need help with creating macro so that the profile sheet can be printed in pdf format in a specific location. The pdf should be saved in the format "DP Code - Branch Name" for each branch or the profile of the entire 481 branches can be exported in a single file with sequence as per RO Name. Also it would be extremely helpful if the pdf export can be done by selecting the RO Name into a single file or creating different macros for each RO so that profiles of all branches under the RO can be saved in a single file.