Hello.
I am looking for VBA solution to loop through column A and to enter formula =Today() in all blank cells in range A2:A1000 if adjacent cell in column B is not empty. For example in table below formula would need to be inserted in cells A3;A7, because they are blank and adjacent cells B3:B7 are not empty.
Best regards
<tbody>
</tbody>
I am looking for VBA solution to loop through column A and to enter formula =Today() in all blank cells in range A2:A1000 if adjacent cell in column B is not empty. For example in table below formula would need to be inserted in cells A3;A7, because they are blank and adjacent cells B3:B7 are not empty.
Best regards
A | B |
24/11/18 | A |
24/11/18 | B |
B | |
B | |
B | |
B | |
B | |
<tbody>
</tbody>