I am pretty new using VBA
I have a simple goal.
I want to use VBA to input a formula in every blank cell in column H only IF the cell in Column B on the same row has a number. If the cell in column H is not blank, I do not want the VBA to erase its contents, and if Column B is blank or has any text other than just a number, I don't want any changes to that row
Here is the formula
=IF(B11>0,INDEX(REPORT!A:B,MATCH(CONCATENATE("Char #",B11),REPORT!A:A,0)+1,2),"")
Thanks for any help!
I have a simple goal.
I want to use VBA to input a formula in every blank cell in column H only IF the cell in Column B on the same row has a number. If the cell in column H is not blank, I do not want the VBA to erase its contents, and if Column B is blank or has any text other than just a number, I don't want any changes to that row
Here is the formula
=IF(B11>0,INDEX(REPORT!A:B,MATCH(CONCATENATE("Char #",B11),REPORT!A:A,0)+1,2),"")
Thanks for any help!