jb
Member
Hi Helpers.
I have an excel sheet to get faculty wise timetable (Monday to Saturday).
In this sheet, I enter faculty code and based on this short code, data will be filled in the table.
I can then save this excel sheet as pdf and give it to respective faculty.
But this is time consuming because I have around 30 faculty. Also, in case of change in timetable, I need to repeat this process.
What I want to do is, I want to have vba code which will take all the faculty codes one by one (I have entered all faculty codes in another sheet of same workbook),
fill the data in the table and save the sheet as pdf with file name same as faculty code in desired folder.
Actually, I have VBA code which can create pdf of existing excel sheets in desired folder. But I am facing problem in this requirement.
I have attached sample file with this.
sheet1 contains list of faculty. This is sample file so only 5 codes are entered. This list can have more codes.
Timetable data is available in MASTER sheet.
In FACULTYWISE sheet, I am entering faculty code in c3 cell.
Based on entered value, table is filled.
I need vba code which will generate individual pdf with file name as faculty code. I need to enter faculty code.
I have searched and got the code somewhat matching with my requirement but unable to customize as per my requirement.
I have an excel sheet to get faculty wise timetable (Monday to Saturday).
In this sheet, I enter faculty code and based on this short code, data will be filled in the table.
I can then save this excel sheet as pdf and give it to respective faculty.
But this is time consuming because I have around 30 faculty. Also, in case of change in timetable, I need to repeat this process.
What I want to do is, I want to have vba code which will take all the faculty codes one by one (I have entered all faculty codes in another sheet of same workbook),
fill the data in the table and save the sheet as pdf with file name same as faculty code in desired folder.
Actually, I have VBA code which can create pdf of existing excel sheets in desired folder. But I am facing problem in this requirement.
I have attached sample file with this.
sheet1 contains list of faculty. This is sample file so only 5 codes are entered. This list can have more codes.
Timetable data is available in MASTER sheet.
In FACULTYWISE sheet, I am entering faculty code in c3 cell.
Based on entered value, table is filled.
I need vba code which will generate individual pdf with file name as faculty code. I need to enter faculty code.
I have searched and got the code somewhat matching with my requirement but unable to customize as per my requirement.
Last edited: