DATA TABLES and multiple sheets
 

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 ?

Thanks a lot

Paolo

Italy


--
kayard
------------------------------------------------------------------------
kayard's Profile: http://www.excelforum.com/member.php...o&userid=24716
View this thread: http://www.excelforum.com/showthread...hreadid=389869

"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 ?

Posted this earlier in response to your other post in .newusers

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