View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sean Cooper Sean Cooper is offline
external usenet poster
 
Posts: 3
Default 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!
!