Vignesh Veerasamy
Member
Dear Excel Gurus,
Greetings. Below are the requirements that user requested me.
#1.One of my user requirement is creation of a new sheet with defined template as shown in sheet named as sample - users will be sent this and create the required sheets based on the Projects pertaining to their department. ( it shall be useful if sheet numbers is taken as input before creation of the required output.
#2.Multiple sheet printing to convert the same into PDF with defined template and alignment to fit the print area as it will be circulated to senior management.
I know point#1 is possible with macro but I am not well versed in macro hence seeking your help and guidance for the same.
Is it possible for case of point#2.
Kindly guide.
I have attached a sample template for above requirement.
Thanks in Advance.
Greetings. Below are the requirements that user requested me.
#1.One of my user requirement is creation of a new sheet with defined template as shown in sheet named as sample - users will be sent this and create the required sheets based on the Projects pertaining to their department. ( it shall be useful if sheet numbers is taken as input before creation of the required output.
#2.Multiple sheet printing to convert the same into PDF with defined template and alignment to fit the print area as it will be circulated to senior management.
I know point#1 is possible with macro but I am not well versed in macro hence seeking your help and guidance for the same.
Is it possible for case of point#2.
Kindly guide.
I have attached a sample template for above requirement.
Thanks in Advance.