automatically add rows when transfer data from userform to sheet1


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 



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: 6) Jun 24, '19 at 6:51 am
Add to Discussion


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




thank so much that what i want  well done buddy
leopard (rep: 6) 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