Hi Guys
Hopefully a very simple VBA solution to this.
I have a vlookup formula in say cell "F2" that is dependent upon a value appearing in cell "E2".
What I am after is some VBA code that, when a value appears in cell "E3", the vlookup formula in cell "F2" 'copies' itself to cell "E3" and so on, maybe all the way to the end of the column.
Simple as that !!
I am aware that i could just copy "F2" down say 20k rows, but im more concerned with understanding the VBA coding
Thanks in advance
Hopefully a very simple VBA solution to this.
I have a vlookup formula in say cell "F2" that is dependent upon a value appearing in cell "E2".
What I am after is some VBA code that, when a value appears in cell "E3", the vlookup formula in cell "F2" 'copies' itself to cell "E3" and so on, maybe all the way to the end of the column.
Simple as that !!
I am aware that i could just copy "F2" down say 20k rows, but im more concerned with understanding the VBA coding
Thanks in advance