DATA TABLES and multiple sheets

K

kayard

Is it true that the input cell (the one whose value changes according t
row/collum value in order to calculate different results) cannot be i
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

Ital
 
M

Max

kayard said:
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 ?
Click to expand...

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
 
Top