I’m trying to set up a verification flow, to make sure a web grid is filled in correctly.
I have performed an example of processing.
I need to search if there are empty cells, in the columns:
F; G; H; I; J; K and then take the value of column A for each row.
In the attached example:
Cell F14 is empty.
So I need to retrieve the value entered in cell A14. “AVL0006725”.
and, again, the cell H18 is Empty… then I need value in A18 (AVL0006747)…
The data collected in Cell A, I need to go to the Web to correct the specific row.
So for each ROW, with an empty value, I have to perform some dispositive actions.
So maybe I need to create a new table, with only the rows to be corrected? I do not know…
The number of lines is variable.
The number of columns is fixed.
The Range only affects columns F to J. (or alternatively A and J).
New Microsoft Excel Worksheet.xlsx (11,1 KB)
Can anyone tell me how to do it?