Excel 2007 : Link to a particular case in another workbook

[linking]

I am trying to link to another workbook, which has a switch and displays three different cases. I want to link to the workbook in such a way that I can show case 1, whatever case is actually chosen in the workbook. (And I want to do this for cases 2 and 3 as well).

Basically I want to show all three cases at the same time - is there a way to do this?

[shg]

Duplicate post, thread closed.

Please take a few minutes to read the forum rules.