"kayard" wrote:
Is it true that the input cell (the one whose value changes according to
row/collum value in order to calculate different results) cannot be in
another sheet ?

I tried without success but I'd like a confiration from your side

If it is true, is there a workaround ?

AFAIK*, yes, the data table has to be set-up in the same sheet. One
workaround would be simply to create a mirror in another sheet, say Sheet2
via using link formulas, e.g. In B2: =Sheet1!B2, then filled across & down
to populate the same range size as the source data table created in Sheet1

*Except perhaps only for this kind of instance where creating data tables
for randomization purposes will work in a separate sheet.
See: http://tinyurl.com/9o66f
where the data table is set-up in another Sheet2
with the source data/formulas in Sheet1
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----