Badly need help on fetching data from an excel file and entering it into a drop down.
So I have an excel file that look like this.
So here are my problems:
When I tried entering the value ONE from row TEAM to its drop down, the bot will read it but will return error as the values from drop down are typed in (proper case) One, Two and so on.
I just need to get the value of the previous month. Say today is 8/1/19, I need to get the value of row “Jul” and enter them in a drop down but the values available in the drop down are Pass, Waived and Failed. 1= Pass, 0=Waived and -1=Failed.
Please help. Thanks!