I have a String DataTable (can vary in amount of rows) containing 9 columns. Columns 0-5 are the result from a read range from Sheet 1 in an Excel sheet. Column 6-9 are information containing “Exception” or “No exception” concerning different categories.
What I need to do is loop through each row in the DataTable and check if any of the rows contains ann exception, and if they do: I want to copy this row (Column 0-5) to Sheet 2 in the excel sheet.
I also want to mark a column G in the first sheet as “Yes” if the row did contain an exception.
Desired result in Sheet 1:
Thank you much in advance!