ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Newbe trying to do Dynamic Parameters from a Worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/127122-newbe-trying-do-dynamic-parameters-worksheet.html)

Sean Cooper

Newbe trying to do Dynamic Parameters from a Worksheet
 
Hello All,

I have been able to setup the ODBC, use the query edit to create my query
and get the info to my worksheet.

Now, I would like to select a row, column or area in my worksheet to obtain
the multiple cells of data from user input. The data looks like

12345 | 54321 | 00001 ( list can get long)

and put it in my query like:

Select emp.name, emp.id from emp where emp.id in ( 12345, 54321, 00001);

Can someone point me in a direction and thanks!
!


All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com