Query Wizard - filter data to match value in spreadsheet cell samsquared 15.11.2005 14:26:17 I have a spreadsheet that contains a drop-down list with values. When the user selects a value I want to get external data from a Perforce (scource code control) database. In the 'Filter data' in the query wizard I'd like to specify the value selected by the user in the spreadsheet but I don't know how to do that. Getting the external data works if I specify a value to filter by, but I want it to use the one the user selected. How do I do that?

Re: Query Wizard - filter data to match value in spreadsheet cell Bill Manville <Bill-Manville[ at ]msn.com> 16.11.2005 00:26:00 Try entering [Which Value?] as the filter criterion in the query wizard. When you refresh the query it should ask you which value. (Mine is currently broken so I haven't tested this) Assuming that works you can then tell the query to take the parameter from a cell, to which you would link the dropdown box, and you can tell it to refresh the query whenever the value in that cell changes. Bill Manville MVP - Microsoft Excel, Oxford, England

Re: Query Wizard - filter data to match value in spreadsheet cell samsquared 16.11.2005 00:57:02 Thanks for your assistance. I can do the parameter query but how do I point it to a cell reference? "Bill Manville" wrote: [Quoted Text] > Try entering [Which Value?] as the filter criterion in the query wizard. > When you refresh the query it should ask you which value. > (Mine is currently broken so I haven't tested this) > > Assuming that works you can then tell the query to take the parameter from a cell, to which you > would link the dropdown box, and you can tell it to refresh the query whenever the value in that > cell changes. > > > Bill Manville > MVP - Microsoft Excel, Oxford, England > >

Re: Query Wizard - filter data to match value in spreadsheet cell Bill Manville <Bill-Manville[ at ]msn.com> 16.11.2005 13:28:58 You haven't said which version of Excel you are using. On the External Data toolbar, click the Query Parameters button (3rd button) and the dialog should direct you to how to do it if your version of Excel has that facility. Bill Manville MVP - Microsoft Excel, Oxford, England