Hi all. I have this Spreadsheet with over 500 tabs (sheets)
At each tab, I must find a cell with the value “N°.:”
Suppose at sheet “245”, UiPath finds “N°.:” at N41
Up to this point I was able to do it.
Now I must count the rows of data inserted under N41, starting at N42.
So I have this variable (VarNum) that should be assigned readings at N42, N43, N44… until there is a blank cell.
-While: Not string.IsNullOrWhiteSpace(VarNum)
Ok, here is my problem. I have N41 as the cell where I found the value. How do I increase only the row of the cell?
In theory, I want to have a DO WHILE where I read cell N42, add +1 to the row, assigning to the variable cell the same value +1 row, thus becoming N43, then check if the value is empty. If it’s not empty, add one more so it becomes N44.
All the while, I count the number of loops (let’s say, 4 rows of data), so I can use that number to create a data table