Columns E & G are blank - I add text to them - H is where the balance is automatically entered.
At the moment, if I add any entry below the last current row nothing happens to the total in the final column (H), I have to add rows above the last row to make it work. Is there a way I can make the total in the final column automatically move down and update as I add more data?
An additional refinement would be to have each column self-total as I added data, and for the final column total to ignore the self-totalling in the other columns.
Or am I getting ahead of myself? I can email a sample dummy file if it helps.
Thanks for responding. What I want to be able to do is enter data on a new row, and have the total from the final column in the row above automatically jump down a row, so that as I add new rows the total moves down with me.