(Most likely) very simple solution. I need to write a macro that will autofill a formula down a column until the last row of the column to the left (let's just say Column C has 18000 populated rows, the macro needs to autofill the formula in D2 down to D18000).