Automatically add a blank row via macro, vba

[rcom]

Hi,

Please download the sample workbook first.

I am just learning macro.

Here What I want is:

1. My data will start saving from "A9"
2. As you can see from my sample book "A19" is called as "Total" and "E19" Will show the sum of "E9:E18"
So if I start saving data and it reached to "A19" then it will automatically add a blank row.
3. In my form Summary will show all the money collected.


Sorry for my poor English.


I have also posted this link on: https://www.mrexcel.com/board/thread...o-vba.1124482/

Thanks in advance.

[Richard Buttrey]

Why not finally leave the pencil and paper era?

I know we all used to have totals at the bottom of sheets of paper and carry forward balances as necessary, but why not enter the 21st century and keep a total at the top of the sheet so that the SUM formula never needs to be changed. Just make it cover sufficient rows for all eventualities.

[rcom]

As you can see I have three requirements. If you please do that and upload the updated file will be great.

Thanks

[rcom]

Anyone please can help me.

[rcom]

Is there no one who will be kind enough to reply!!!!!!!!!

[rcom]

Its really important