Please help....!!!! How can i add multiple rows.... But I don't want values... I want to put formula in it.... Like.... Name Marks Marks JACK 60 80 =Sum(B2+C2) RYAN 78 40 =Sum(B3+C3) I want to drag it to till my data.... So that if i Increase my data.... It will work... It should work till my data, not on the after rows...
I think you can simply copy paste formula till the last row where data is. If you want to add rows with VBA, you can see this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PMHhr598vaE.html
Could you please share the code...... And there's is only two people But next time... There could be 4, 5, 6.... & more... So i don't want to change range, everytime i run the macro....
ok. Here is the video I created today to how to find last empty row and copy paste formulas till last filled row. Dont forget to hit the like button if this solves your problem. :) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-a4nUFmFUPZE.html