I have an excel file with 2 columns namely ‘Number’ and ‘Status’(PFA). The status can be ‘Y’ or ‘N’.
Now, depending on the status, I need to read the number from the column named ‘Number’.
If the status is ‘N’ copy the number corresponding to the status, paste it to some
location and set the status to ‘Y’.
If the status is ‘Y’ go to the next row to check the status and the process continues until we find a number with status ‘N’.
Can anybody help me with the logic here?
Number_Status.xlsx (9.7 KB)