I still need help!
 

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.

A B C D E
F G
1:
2: distance 20
3: sections 5
4:
5: 1 2 3 4 5
6:


If you can help, please explain in as basic of terms as possible.

Thank yo

--
rbheda
-----------------------------------------------------------------------
rbhedal's Profile: http://www.excelforum.com/member.php...fo&userid=2819
View this thread: http://www.excelforum.com/showthread.php?threadid=47843

I still need help!
 

there are answers to your posts from the other day, if they don't work,
elaborate in that thread so we know what you are trying to accomplish.
starting a new thread is not helping.

--


Gary


"rbhedal" wrote in
message ...

I have a slight problem that Excel either can not do or I can not enter
the formula correctly. I am asking for your expertise. What I need is
to enter Value A into a cell and then enter Value B into a cell, have
Excel do the division, and then generate a table with that number of
rows. For example, if I enter "20" into cell A2, enter "5" into cell
B2, I need Excel to generate a table in cell C5 that starts at 1 and
then in cell D5 is 2, then 3 in cell E5, etc....

The number that I enter for the prompt "sections" is the number of
columns that I need Excel to generate. I need Excel to do this
automatically (preferably without the user having to "click and drag"
anything. I have included an example output of what I need the
spreadsheet to look like to, hopefully, help explain my idea. It is set
up just like a spreadsheet; where the letters represent the columns &
the numbers (on the left) represent the rows.

A B C D E
F G
1:
2: distance 20
3: sections 5
4:
5: 1 2 3 4 5
6:


If you can help, please explain in as basic of terms as possible.

Thank you


--
rbhedal
------------------------------------------------------------------------
rbhedal's Profile:
http://www.excelforum.com/member.php...o&userid=28199
View this thread: http://www.excelforum.com/showthread...hreadid=478432