I have a list of data with a formula in column b. I only want that formula in rows where there is something in column a. My data starts at row 12 and I would like to copy the formula in B12 down through the last row that there is something in column A... using VBA / Macro.

Thanks in advance!