If I have a formula in a cell such as M1 and want to copy it to the last row
to duplicate the formula in each of the cells in the M collumn, how can I do
that quickly without just dragging it down the collumn. This takes alot of
time if I have 30,000 + rows and alot of formulas.

Thanks

JLD