XL 2000: MS Query reference to multiple cells

[locutis]

Hello and Happy New Year!

Here's what I have: 3 display sheets, 1 data sheet with MS Queries pointing to SQL Server 2000 db. First query on data sheet takes the input parameter value from cell on Sheet1(=Sheet1!$B$2) which other queries key off of, works fine. I only need this same data sheet for all 3 display sheets, which are already mapped to the data sheet. Is it possible to have a formula that will allow the input parameter value from another cell? For instance (psuedocode): IIF cell reference =Sheet1!$B$2 OR =Sheet2!$B$2 OR =Sheet3!$B$2?

I wasn't sure how to do it on MS Query cell or if it's possible (right click-->Parameters-->"Get the value from the following cell:" (radio button selected) I want to avoid having to create two new data sheets and the tedious job of updating the cell references on the other two display sheets (Sheet2 and Sheet3).

Thanks,
Jean Luc

 

[SkipVought]

So you make a formula like this in a cell for your parameter...
[tt]
if(isblank(Sheet1!$B$2),if(isblank(Sheet2!$B$2),if(isblank(Sheet3!$B$2),"",Sheet3!$B$2),Sheet2!$B$2),Sheet1!$B$2)
[/tt]


Skip,
[sub]
[red][/red]
[/sub]