L
Louise
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,
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,