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.

Thanks in advance.

I have posted this topic on another site.

Automatically add a blank row via macro, vba

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"

www.excelforum.com

 

[rcom]

No one here who can help me!!!!!!!!!!!!!!