All Functions & Formulas
Tuesday, August 20, 2013
Google Spreadsheet Dynamically create rows of data with user input
I want to enter a number like 15 into cell B4 and another number like 50 into cell B7.
Then I want A11's value to start on B7.
Then i want A12 to be =SUM(A11 +1)
I want this to keep on going while the number of created rows is less than or equal to B4.
So I want 15 (or whatever number is dynamically entered into B4) new rows of numbers in just 1 column adding 1 to the previous number and the numbers need to start on B7's value.
so it would look like this
B4 = 4
B7 = 20
so 4 new rows, starting at 20, adding 1 each new row.
Thanks in advance,
Have a look at the following animated screenshot:
I have the following formula in Cell A11:
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.
I also take up private and confidential projects:
If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here:
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)