Hello Friends,
I want to mark an excel sheet as Pass/Fail after reading all of the data in columns C and D. For instance, the bot should read all of the data in Column C; if any blank cells are present, it will write Fail in Excel; otherwise, it will write Pass. The process is the same for Column D.
Find the sample data that is attached, where sheet 2 has the data and sheet 3 contains the output.
Datascraping.xlsx (10.0 KB)
Please help me with solution