Is there a way to specify functions to be filled down each column even when rows are inserted?
What I am trying to do is have the balance column with a simple function: if column C is the amount and column d is the balance:
with this function copied down the whole column even when new rows are inserted using the macro you gave me.
I'm not sure how to do this because the macro copies the row to the bottom first (I think...) and then sorts it - so the formula would have to be copied once the sorting was finished...
I'm new to macros if you didn't notice
Bookmarks