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?
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
Thanks for your assistance. I can do the parameter query but how do I point it to a cell reference? "Bill Manville" wrote: > 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 > >
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
