I’m new to the community. I’m not a developer, just try to create some bot to automate some tasks to lighten the workflow of my team.
I have an excel file with will be processed row by row, for each row that is processed the Status will be Completed, otherwise it’s remains Incompleted.
I would like the bot to filter the status column, get the first RefNumber (the cell in the first row and in Refnumber column after filtered) to proceed further.
Can you show me how to do it.
The sample file is below:
Appreciate all the help from you guys.
Thank you so much in advance.