Is there a way to Copy a formula from one cell to the end of the rows with no
data.
I currently have a formula in cell B2 which I would like to automatically
copy down the same length as Col A:A.
The trouble is col A:A change length all the time. Is there a way to count
the number of rows require then autofill the formula to the same number?

Regards
Jim