not sure if it can be done how you explain it. you need to have some sort of
consistency with where you will be entering your numbers and where you want
the results you mention a2 and a3 and then c4 in one paragraph and in the
other you mention c5.

maybe if you kept them all in the same row. maybe someone else can
interpret what you mean, .but i need further explanation.
--


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 C4 that starts at 1 and
then in cell D4 is 2, then 3 ....

If further elaboration is needed, what I am looking for is this. If I
have a distance of say 20 meters & I want to break it into 5 equal
sections. I will enter 20 in cell A2 and enter 5 in cell A3. I want
Excel to realize (from my input of 5) that I want 5 columns. Say I
enter the "code" in cell C5 I want Excel to place a "1" in cell C5, &
in cell D5, place a "2", in D6, place a "3"... until it reaches the
nmber of sections that I asked for. I hope this is clear & I hope that
someone can help.

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=477787