Hi all! So far I have successfully attempted in getting the robot to check to ensure that when cell n11 is = to attendance sheet countif, it will indicate a tick symbol on the appendix excel document. My question is, how do I make it dynamic? I have several other attendance to check through and would like the robot to go through the docs in the folder.
@prasath17 Thanks prasath17. Currently, the robot will first ensure that the Class ID matches with the attendance sheet ID, then it will proceed to check if cell N number is = to attendance sheet number through a countif in Attendance_template > Attendance Sheet L74 : L86. If it matches, it will indicate a tick symbol in the appendix excel row.
How do I proceed to make the bot dynamic whereby it goes through a lists of attendance sheet with the appendix class ID? Right now, my code is static.
@ClaytonM I tried For each file in folder. However, I have no idea how to define the path along with stating the if condition attendance sheet to be dynamic. Currently, it just checks for that specific excel file - cell B1.
As you could see, I wrote the formula straight away in the Appendix sheet by including IF condition…I have also tried to include Count IF also here…but it was keep failing…So only thing you have to do build a separate loop beginning of the workflow to process all the Attendance file and write the Count if results to M86.