Hello,
I have an excel sheet with multiple tabs that I want to loop through data and based on whether a cell is empty. My thought was that I could grab the data in a tab and then use a "for each" loop to go line by line. I set an index for the specific cell I am looking at and have a display message to show me the values as a way to check the information. I checked to make sure I am grabbing the data from each tab but I dont know if there is a way to step through and identify where I am at in the sheet because my message keeps coming up as blank.
Above is my subflow where I loop through the data.
Here is the message that I am using to make sure I am pulling my data from the correct sheet.
This is the message where I am trying to display the specific row information based on the current item in my loop.
I do not believe I am looking through the right data because I can watch it loop through and not capture rows that it should based on a count.
Any help is appreciated.
Thanks!
