Identify and Paste Down (autofill) a Formula- Help Please...
 

Hi

I have a spreadsheet with data in it which a user will add data too each
month. I have a macro that gets the new data and dumps it into a all months
template sheet, and finds the last cell in column C, adds a formula to the
one underneath it, but then I need to autofill that formula down to the end
of the data (and undefined number on rows) in that column. I can only find
code which specifies to use a specific cell to copy and paste the formula
down, but this will always change - What code could I use to do this?

Many Thanks,