I am very new at macros and had recorded one for a worksheet I use all the
time. I copied/pasted the macro into another workbook that I could use this
the macro for but there is less data and has the potential to grow. In the
macro I recorded I had copied a formula and then autofilled down to last row
of data. How do I edit the macro to find last row and copy the formula down.
I am ending up with unecessary rows of formulas where there is no data.