How to do Nested For Each Excel Row

Help Activities
, , ,
4

  1. So actually there are two excel sheets that I use in this process.

  2. From this workflow I want to process the first sheet with blank value then I use CurrentRow = Nothing.

  3. Then if there is no blank value in the first sheet, I do the same process in the second sheet to process the blank value of the second sheet Row = Nothing

  4. After I process all the blank value row in each sheet, I want to process each row in the second sheets but each row in the second sheet should be the same value as the first sheet and if there is still a same value in the second row as the value in the first sheet then I want it to be processed in loop, so I use Row().tostring = CurrentRow().tostring, but as of now the process didn’t work as I expected, it didn’t process in loop in the last For Each with that If activity condition, so I assume there is something wrong either in the for each or the if condition.

So that’s it, if there is any feedback please help me.