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.
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
Attachments
Last edited by a moderator: