R
rbhedal
I have a slight problem that Excel either can not do or I can not ente
the formula correctly. I am asking for your expertise. What I need i
to enter Value A into a cell and then enter Value B into a cell, hav
Excel do the division, and then generate a table with that number o
rows. For example, if I enter "20" into cell A2, enter "5" into cel
B2, I need Excel to generate a table in cell C5 that starts at 1 an
then in cell D5 is 2, then 3 in cell E5, etc....
The number that I enter for the prompt "sections" is the number o
columns that I need Excel to generate. I need Excel to do thi
automatically (preferably without the user having to "click and drag
anything. I have included an example output of what I need th
spreadsheet to look like to, hopefully, help explain my idea. It is se
up just like a spreadsheet; where the letters represent the columns
the numbers (on the left) represent the rows. The blue numbers/letter
represent the rows/columns of the Excel spreadsheet. The purple number
are inserted by the user and the bold red numbers are the numbers that
need Excel to generate & place.
Code
-------------------
A B C D E F G
1:
2: distance 20
3: sections 5
4:
5: *1 2 3 4 5*
6: deltaX: (to be input by user, no code needed)
-------------------
If you can help, please explain in as basic of terms as possible.
Thank yo
the formula correctly. I am asking for your expertise. What I need i
to enter Value A into a cell and then enter Value B into a cell, hav
Excel do the division, and then generate a table with that number o
rows. For example, if I enter "20" into cell A2, enter "5" into cel
B2, I need Excel to generate a table in cell C5 that starts at 1 an
then in cell D5 is 2, then 3 in cell E5, etc....
The number that I enter for the prompt "sections" is the number o
columns that I need Excel to generate. I need Excel to do thi
automatically (preferably without the user having to "click and drag
anything. I have included an example output of what I need th
spreadsheet to look like to, hopefully, help explain my idea. It is se
up just like a spreadsheet; where the letters represent the columns
the numbers (on the left) represent the rows. The blue numbers/letter
represent the rows/columns of the Excel spreadsheet. The purple number
are inserted by the user and the bold red numbers are the numbers that
need Excel to generate & place.
Code
-------------------
A B C D E F G
1:
2: distance 20
3: sections 5
4:
5: *1 2 3 4 5*
6: deltaX: (to be input by user, no code needed)
-------------------
If you can help, please explain in as basic of terms as possible.
Thank yo