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