Hello,
Thanks in advance for any help!
I need to create a macro for inserting a simple product formula in all cells with data adjacent to that cell. I want the macro to insert "=product(G1*I1)" in H1, "=product(G2*I2)" in H2 and so on, down the column until it reaches a cell where no data exists in the cell adjacent to Hx.
Thanks!
Thanks in advance for any help!
I need to create a macro for inserting a simple product formula in all cells with data adjacent to that cell. I want the macro to insert "=product(G1*I1)" in H1, "=product(G2*I2)" in H2 and so on, down the column until it reaches a cell where no data exists in the cell adjacent to Hx.
Thanks!