Does anyone know if Excel's Data Table works if the assumptions and calculations are on say Sheet1 and the table/'s are displayed on say Sheet2, because it won't work for me.?
There must be a sneaky little trick to it that I don't know maybe. Thanks.