sor right now i have a loop that shows a message box saying if there is a number in column K, but column Q is blank, it'll display the blank row number for the analyst to fill in the blank in column Q with the necessary info.
however, rather than having the analyst jot down the row number, i want the macro to put the row number in column AA and of course build on the list if there is more than one row where the condition is true (i.e., number is column K, but column Q is blank)
however, rather than having the analyst jot down the row number, i want the macro to put the row number in column AA and of course build on the list if there is more than one row where the condition is true (i.e., number is column K, but column Q is blank)