SOLVED

Seek for Help: How to print out 695 pieces of Attendance Report in batch into PDF file?

%3CLINGO-SUB%20id%3D%22lingo-sub-2463406%22%20slang%3D%22en-US%22%3ESeek%20for%20Help%3A%20How%20to%20print%20out%20695%20pieces%20of%20Attendance%20Report%20in%20batch%20into%20PDF%20file%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2463406%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3ESeek%20for%20Help%3A%20How%20to%20print%20out%20695%20pieces%20of%20attendance%20report%20in%20batch%20into%20PDF%20files%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20print%20out%205%20pieces%20of%20monthly%20report%20January-May%202021%20for%20each%20and%20every%20employee.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20developed%20an%20attendance%20reporting%20spreadsheet%20but%20cannot%26nbsp%3Bprint%20out%20695%20pieces%20of%20attendance%20report%20in%20batch%20into%20PDF%20files.%20I%20need%20help.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3E%3CSTRONG%3EBasic%20Information%3A%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%3CP%3EFor%20your%20information%2C%20following%20is%20a%20simple%20calculation%20concerning%20my%20need.%26nbsp%3B%3C%2FP%3E%3CP%3ETotal%20Number%20of%20Employee%20%3D%20xxx%20Persons%3C%2FP%3E%3CP%3ETotal%20Report%20for%20Printing%20%3D%20xxx%20Persons%20*%205%20Monthly%20Reports%20%3D%20695%20Monthly%20Reports%20(This%20is%20the%20reason%20why%20I%20need%20to%20print%20out%20695%20Monthly%20Reports.)%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CU%3E%3CSTRONG%3ESeek%20for%20Help%3A%20What%20do%20I%20need%3F%26nbsp%3B%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%3CP%3EPlease%20teach%20me%20how%20to%20generate%20695%20pieces%20of%20attendance%20report%20in%20batch%20into%20PDF%20files%20by%3A%3C%2FP%3E%3COL%3E%3CLI%3EAuto-filling%20in%20Month%20(January%2C%20February%2C%20March%2C%20April%2C%20May)%3C%2FLI%3E%3CLI%3EAuto-filling%20in%20Division%20(D1%2C%20D2%2C%20D3%2C%20D4%2C%20D5)%3C%2FLI%3E%3CLI%3EAuto-filling%20in%20Section%20(D1S1%2C%20D1S2%2C%20D1S3%2C%20D1S4%2C%20D2S1%2C%20D2S2%2C%20D3S1%2C%20D3S2%2C%20D3S3%E2%80%A6.)%3B%20Remarks%3A%20The%20number%20of%20section%20are%20not%20all%20the%20same%20in%20various%20division.%3C%2FLI%3E%3CLI%3EAuto-filling%20in%20Employee%E2%80%99s%20Name%20(D1S1N1%2C%20D1S1N2%2CD1S2N1%2C%20D1S2N2%2C%20D1S3N1%2C%20D1S3N2%2C%20D1S4N1%2C%20D1S4N2%2C%20D2S1N1%2C%20D2S1N2%2C%20D2S2N1%2C%20D2S2N2%2C%20D3S1N1%2C%20D3S1N2%2C%20D3S2N1%2C%20D3S2N2%2C%20D3S3N1%2C%20D3S3N2%E2%80%A6.)%3B%20Remarks%3A%20The%20number%20of%20employee%20are%20not%20all%20the%20same%20in%20various%20section.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3E%3CSTRONG%3EWhat%20I%20had%20done%3F%20What%20I%20am%20having%20now%3F%3C%2FSTRONG%3E%3C%2FU%3E%3CBR%20%2F%3E1.%20I%20had%20developed%20a%20frontpage%20in%20one%20of%20the%20spreadsheets.%20I%20had%20created%20several%20Dynamic%20Dependent%20Drop-down%20Lists%20in%20the%20frontpage.%20User%20can%20select%20Month%2C%20Division%2C%20Section%20and%20Name%20in%20the%20Frontpage.%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20I%20had%20also%20developed%20a%20Report%20Page%20for%20user%20to%20view%20staff%20attendance%20monthly%20report%20by%20selecting%26nbsp%3BMonth%2C%20Division%2C%20Section%20and%20Name%20in%20the%20Frontpage.%20All%20the%20necessary%20formulae%20are%20developed%2C%20such%20as%3A%3C%2FP%3E%3CP%3E2.1%26nbsp%3B%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EVLOOKUP%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E(%3C%2FSPAN%3E%3CSPAN%3EC6%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%3Estaff!B1%3AD140%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22number%22%3E2%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22boolean%22%3EFALSE%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E2.2%20%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EVLOOKUP%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E(%3C%2FSPAN%3E%3CSPAN%3EC6%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%3Estaff!B1%3AD140%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22number%22%3E3%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%2C%3C%2FSPAN%3E%3CSPAN%20class%3D%22boolean%22%3EFALSE%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E2.3%26nbsp%3B%3Dmin(FILTER(%3CSPAN%3Ehadir!%24E%242%3A%24E%249531%3C%2FSPAN%3E%2C(%3CSPAN%3Ehadir!%24J%242%3A%24J%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3E%24C%246%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24B%242%3A%24B%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3E%24C%244%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24F%242%3A%24F%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%22Masuk%22%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24C%242%3A%24C%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3EA11%3C%2FSPAN%3E)))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E2.4%26nbsp%3B%3Dmax(FILTER(%3CSPAN%3Ehadir!%24E%242%3A%24E%249531%3C%2FSPAN%3E%2C(%3CSPAN%3Ehadir!%24J%242%3A%24J%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3E%24C%246%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24B%242%3A%24B%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3E%24C%244%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24F%242%3A%24F%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%22Keluar%22%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24C%242%3A%24C%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3EA11%3C%2FSPAN%3E)))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E2.5%26nbsp%3B%3D%3CSPAN%3ED11%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E-%3C%2FSPAN%3E%3CSPAN%3EC11%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E-%3C%2FSPAN%3ETIME(%3CSPAN%20class%3D%22number%22%3E1%3C%2FSPAN%3E%2C%3CSPAN%20class%3D%22number%22%3E0%3C%2FSPAN%3E%2C%3CSPAN%20class%3D%22number%22%3E0%3C%2FSPAN%3E)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E2.6%26nbsp%3B%3DUNIQUE(FILTER(%3CSPAN%3Ehadir!%24G%242%3A%24G%249531%3C%2FSPAN%3E%2C(%3CSPAN%3Ehadir!%24J%242%3A%24J%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3E%24C%246%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24B%242%3A%24B%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3E%24C%244%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24F%242%3A%24F%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%22Masuk%22%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24C%242%3A%24C%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3EA11%3C%2FSPAN%3E)))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E2.7%26nbsp%3B%3DUNIQUE(FILTER(%3CSPAN%3Ehadir!%24G%242%3A%24G%249531%3C%2FSPAN%3E%2C(%3CSPAN%3Ehadir!%24J%242%3A%24J%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3E%24C%246%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24B%242%3A%24B%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3E%24C%244%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24F%242%3A%24F%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%22Keluar%22%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24C%242%3A%24C%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3EA11%3C%2FSPAN%3E)))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E2.8%26nbsp%3B%3DUNIQUE(FILTER(%3CSPAN%3Ehadir!%24G%242%3A%24G%249531%3C%2FSPAN%3E%2C(%3CSPAN%3Ehadir!%24J%242%3A%24J%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3E%24C%246%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24B%242%3A%24B%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3E%24C%244%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24F%242%3A%24F%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%22Keluar%22%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24C%242%3A%24C%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3EA11%3C%2FSPAN%3E)))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E2.9%26nbsp%3B%3DUNIQUE(FILTER(%3CSPAN%3Ehadir!%24L%242%3A%24L%249531%3C%2FSPAN%3E%2C(%3CSPAN%3Ehadir!%24J%242%3A%24J%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3E%24C%246%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24B%242%3A%24B%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3E%24C%244%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24F%242%3A%24F%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%22Masuk%22%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24C%242%3A%24C%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3EA11%3C%2FSPAN%3E)))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E2.10%26nbsp%3B%3DUNIQUE(FILTER(%3CSPAN%3Ehadir!%24L%242%3A%24L%249531%3C%2FSPAN%3E%2C(%3CSPAN%3Ehadir!%24J%242%3A%24J%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3E%24C%246%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24B%242%3A%24B%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3E%24C%244%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24F%242%3A%24F%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20string%20%22%3E%22Keluar%22%3C%2FSPAN%3E)%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E*%3C%2FSPAN%3E(%3CSPAN%3Ehadir!%24C%242%3A%24C%249531%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%3EA11%3C%2FSPAN%3E)))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E3.%20All%20necessary%20data%20and%20formulae%20are%20in%20place.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EScreenshot%201%3A%20Frontpage%20in%20Spreadsheet%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22raymondngu_0-1624029660885.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F289924iA5E719F7B381E51D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22raymondngu_0-1624029660885.png%22%20alt%3D%22raymondngu_0-1624029660885.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EScreenshot%202%3A%20Report%20Page%20in%20Spreadsheet%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22raymondngu_1-1624029737195.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F289925i980F64B6E368E3E1%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22raymondngu_1-1624029737195.png%22%20alt%3D%22raymondngu_1-1624029737195.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Fpostpage%2Fboard-id%2FExcelGeneral%23%22%20target%3D%22_blank%22%3EExcel%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Fpostpage%2Fboard-id%2FExcelGeneral%23%22%20target%3D%22_blank%22%3EFormulas%20and%20Functions%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Fpostpage%2Fboard-id%2FExcelGeneral%23%22%20target%3D%22_blank%22%3EMacros%20and%20VBA%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Fpostpage%2Fboard-id%2FExcelGeneral%23%22%20target%3D%22_blank%22%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Fpostpage%2Fboard-id%2FExcelGeneral%23%22%20target%3D%22_blank%22%3ECharting%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Fpostpage%2Fboard-id%2FExcelGeneral%23%22%20target%3D%22_blank%22%3EPower%20BI%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Fpostpage%2Fboard-id%2FExcelGeneral%23%22%20target%3D%22_blank%22%3EDeveloper%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Fpostpage%2Fboard-id%2FExcelGeneral%23%22%20target%3D%22_blank%22%3EOffice%20365%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Fpostpage%2Fboard-id%2FExcelGeneral%23%22%20target%3D%22_blank%22%3EExcel%20for%20web%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Fpostpage%2Fboard-id%2FExcelGeneral%23%22%20target%3D%22_blank%22%3EOffice%20Scripts%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2463406%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2470040%22%20slang%3D%22en-US%22%3ERe%3A%20Seek%20for%20Help%3A%20How%20to%20print%20out%20695%20pieces%20of%20Attendance%20Report%20in%20batch%20into%20PDF%20file%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2470040%22%20slang%3D%22en-US%22%3ELet%20me%20offer%20a%20different%20solution.%20Now%20that%20you've%20had%20123%20views%20and%20no%20replies%20I%20hope%20you'll%20be%20open%20to%20this%3A%20use%20your%20Excel%20file%20as%20a%20source%2C%20and%20Word's%20Mail%20Merge%20capabilities%20as%20the%20way%20to%20batch%20print%20those%20many%20outputs.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2474939%22%20slang%3D%22en-US%22%3ERe%3A%20Seek%20for%20Help%3A%20How%20to%20print%20out%20695%20pieces%20of%20Attendance%20Report%20in%20batch%20into%20PDF%20file%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2474939%22%20slang%3D%22en-US%22%3EDear%20Mr.%20John%2C%20thank%20you%20for%20your%20remedy.%20I%20appreciate%20Word's%20Mail%20Merge%20in%20printing%20personalized%20outputs%20in%20batch.%20Thanks.%3C%2FLINGO-BODY%3E
New Contributor

Seek for Help: How to print out 695 pieces of attendance report in batch into PDF files?

 

I need to print out 5 pieces of monthly report January-May 2021 for each and every employee.

 

I had developed an attendance reporting spreadsheet but cannot print out 695 pieces of attendance report in batch into PDF files. I need help. 

 

Basic Information:

For your information, following is a simple calculation concerning my need. 

Total Number of Employee = xxx Persons

Total Report for Printing = xxx Persons * 5 Monthly Reports = 695 Monthly Reports (This is the reason why I need to print out 695 Monthly Reports.)


Seek for Help: What do I need? 

Please teach me how to generate 695 pieces of attendance report in batch into PDF files by:

  1. Auto-filling in Month (January, February, March, April, May)
  2. Auto-filling in Division (D1, D2, D3, D4, D5)
  3. Auto-filling in Section (D1S1, D1S2, D1S3, D1S4, D2S1, D2S2, D3S1, D3S2, D3S3….); Remarks: The number of section are not all the same in various division.
  4. Auto-filling in Employee’s Name (D1S1N1, D1S1N2,D1S2N1, D1S2N2, D1S3N1, D1S3N2, D1S4N1, D1S4N2, D2S1N1, D2S1N2, D2S2N1, D2S2N2, D3S1N1, D3S1N2, D3S2N1, D3S2N2, D3S3N1, D3S3N2….); Remarks: The number of employee are not all the same in various section.

 

What I had done? What I am having now?
1. I had developed a frontpage in one of the spreadsheets. I had created several Dynamic Dependent Drop-down Lists in the frontpage. User can select Month, Division, Section and Name in the Frontpage. 

2. I had also developed a Report Page for user to view staff attendance monthly report by selecting Month, Division, Section and Name in the Frontpage. All the necessary formulae are developed, such as:

2.1 =VLOOKUP(C6,staff!B1:D140,2,FALSE)

2.2 =VLOOKUP(C6,staff!B1:D140,3,FALSE)

2.3 =min(FILTER(hadir!$E$2:$E$9531,(hadir!$J$2:$J$9531=$C$6)*(hadir!$B$2:$B$9531=$C$4)*(hadir!$F$2:$F$9531="Masuk")*(hadir!$C$2:$C$9531=A11)))

2.4 =max(FILTER(hadir!$E$2:$E$9531,(hadir!$J$2:$J$9531=$C$6)*(hadir!$B$2:$B$9531=$C$4)*(hadir!$F$2:$F$9531="Keluar")*(hadir!$C$2:$C$9531=A11)))

2.5 =D11-C11-TIME(1,0,0)

2.6 =UNIQUE(FILTER(hadir!$G$2:$G$9531,(hadir!$J$2:$J$9531=$C$6)*(hadir!$B$2:$B$9531=$C$4)*(hadir!$F$2:$F$9531="Masuk")*(hadir!$C$2:$C$9531=A11)))

2.7 =UNIQUE(FILTER(hadir!$G$2:$G$9531,(hadir!$J$2:$J$9531=$C$6)*(hadir!$B$2:$B$9531=$C$4)*(hadir!$F$2:$F$9531="Keluar")*(hadir!$C$2:$C$9531=A11)))

2.8 =UNIQUE(FILTER(hadir!$G$2:$G$9531,(hadir!$J$2:$J$9531=$C$6)*(hadir!$B$2:$B$9531=$C$4)*(hadir!$F$2:$F$9531="Keluar")*(hadir!$C$2:$C$9531=A11)))

2.9 =UNIQUE(FILTER(hadir!$L$2:$L$9531,(hadir!$J$2:$J$9531=$C$6)*(hadir!$B$2:$B$9531=$C$4)*(hadir!$F$2:$F$9531="Masuk")*(hadir!$C$2:$C$9531=A11)))

2.10 =UNIQUE(FILTER(hadir!$L$2:$L$9531,(hadir!$J$2:$J$9531=$C$6)*(hadir!$B$2:$B$9531=$C$4)*(hadir!$F$2:$F$9531="Keluar")*(hadir!$C$2:$C$9531=A11)))

3. All necessary data and formulae are in place. 

Screenshot 1: Frontpage in Spreadsheet

raymondngu_0-1624029660885.png

 

Screenshot 2: Report Page in Spreadsheet

raymondngu_1-1624029737195.png

 

Excel

Formulas and Functions

Macros and VBA

BI & Data Analysis

Charting

Power BI

Developer

Office 365

Excel for web

Office Scripts

2 Replies
best response confirmed by student (New Contributor)
Solution
Let me offer a different solution. Now that you've had 123 views and no replies I hope you'll be open to this: use your Excel file as a source, and Word's Mail Merge capabilities as the way to batch print those many outputs.
Dear Mr. John, thank you for your remedy. I appreciate Word's Mail Merge in printing personalized outputs in batch. Thanks.