I have a formula which I want to VBA to insert into a range of cells.
I want to search Column ("G") for the word "Final", then offset -2 columns, and 1 row, insert the formula, drop down, another row and insert the formula again, and then continue looking in Column ("G") for another instance of the value, "Final", and continue to insert an additonal 2 rows of formulas, and continue on.
My problem, is understanding how to change the row references, using vba, as the rows are dynamic in range.
=INDEX(C8:L8,1,MAX(IF(C8:L8<>"",COLUMN(C8:L8)))-COLUMN(C8)+1)
I would appreciate any help, in understanding how to accomplish this.
I want to search Column ("G") for the word "Final", then offset -2 columns, and 1 row, insert the formula, drop down, another row and insert the formula again, and then continue looking in Column ("G") for another instance of the value, "Final", and continue to insert an additonal 2 rows of formulas, and continue on.
My problem, is understanding how to change the row references, using vba, as the rows are dynamic in range.
=INDEX(C8:L8,1,MAX(IF(C8:L8<>"",COLUMN(C8:L8)))-COLUMN(C8)+1)
I would appreciate any help, in understanding how to accomplish this.
