In an excel document, column A's whole cells are filled with numerical values, and column B has additional numbers.
I want to develop a VBA script (or other solutions, if there are any) to manage to change the values in column A.
To be clear, cell A1 can only be changed by the user of Excel if cell B1's value is zero. The same holds true for the succeeding rows; hence, row A2 can only be modified if row B2 is equal to zero, and so forth.
I have searched on the internet but I can't find a good solution, in particular, because this must work on a large number of cells.