• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

EXCEL'S DATA TABLE

LesEwing

New Member
Hi Guys,

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.


Les.♪♫♪♫
 

keymaster

New Member
hmm... did you try using named ranges? (I havent tried, but named ranges overcome this problem wrt conditional formatting)
 
Top