I have a number of formulas which calculate based on the input of 'Agents'.
Agents= {1,2,3,4,5,6,7,8,9,10}. I would like an output of these formulas
based on all instances of 'Agents'.

Specifically, the cell D18 is a SUM calculation of overhead costs. The
cells in the SUM calculation are predicated on cell F3. (Agents). D18
recalculates for each instance of F3. I am trying to output a table of each
of these results, simultaneously.

stan stadelman
excel 2003, windows xp pro

The easiest way to get all the tables at the same time is to make nine copies
of the original worksheet.

In the original sheet set Agents=1
In the first copy set Agents=2
In the second copy set Agents=3


etc. etc.
--
Gary's Student


"Stan" wrote:

I have a number of formulas which calculate based on the input of 'Agents'.
Agents= {1,2,3,4,5,6,7,8,9,10}. I would like an output of these formulas
based on all instances of 'Agents'.

Specifically, the cell D18 is a SUM calculation of overhead costs. The
cells in the SUM calculation are predicated on cell F3. (Agents). D18
recalculates for each instance of F3. I am trying to output a table of each
of these results, simultaneously.

stan stadelman
excel 2003, windows xp pro

That's a good patch, thanks, but is it possible in one sheet? Microsoft
direct support told me I'd need to write a macro.

"Gary''s Student" wrote:

The easiest way to get all the tables at the same time is to make nine copies
of the original worksheet.

In the original sheet set Agents=1
In the first copy set Agents=2
In the second copy set Agents=3


etc. etc.
--
Gary's Student


"Stan" wrote:

I have a number of formulas which calculate based on the input of 'Agents'.
Agents= {1,2,3,4,5,6,7,8,9,10}. I would like an output of these formulas
based on all instances of 'Agents'.

Specifically, the cell D18 is a SUM calculation of overhead costs. The
cells in the SUM calculation are predicated on cell F3. (Agents). D18
recalculates for each instance of F3. I am trying to output a table of each
of these results, simultaneously.

stan stadelman
excel 2003, windows xp pro