Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

automatically add rows when transfer data from userform to sheet1

0

here  i  would add rows in sheet1  every time fill data in userform witout effect on values cells  in my case  it supposes add rows aftera row19   with show the value in the rows(subtotal,total) with lastrow does adding  because  the rows(subtotal,total) link the last row contains data 

Answer
Discuss

Discussion

Hi leopard.
I have had a quick look at your workbook. I guess it originates from a country with a different ethnic origin than mine (NZ) given that it appears to be a right to left orientation rather than my familiar left to right. 
There also appeared to be incompatibility between your character set and mine.
Looking at your description of your issue it looks like you are trying to add new data on the same sheet where you wish to summarize the data.
I would suggest that you separate your data from your summary either to a different sheet or to column off to one side.
k1w1sm (rep: 197) Jun 23, '19 at 10:51 pm
i changed the coordinate th file you can see above 
leopard (rep: 88) Jun 24, '19 at 6:51 am
Add to Discussion

Answers

0
Selected Answer

Hi leopard 

I have had a play with your form and macros. I am still not sure exactly what you want but I have provided some sample code which inserts rows, values and adjust formulas.

Hopefully this will be enough to get you going

Good Luck

K1w1

Discuss

Discussion

thank so much that what i want  well done buddy
leopard (rep: 88) Jun 24, '19 at 10:24 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login