Excel: Use a cell value as a parameter for a SQL query

by

I had the same problem as you, Noboby can understand me, But I solved it in this way.

SELECT NAME, TELEFONE, DATA
FROM   [sheet1$a1:q633]
WHERE  NAME IN (SELECT * FROM  [sheet2$a1:a2])

you need insert a parameter in other sheet, the SQL will consider that information like as
database, then you can select the information and compare them into parameter you like.

More Related Contents:

  1. how should I apply a formula and get answer in all the odd cells?
  2. Sequence of numbers based on start and end value of 2 cells [closed]
  3. How do I find the last column with data?
  4. Vlookup using 2 columns to reference another
  5. How to insert a picture into Excel at a specified cell position with VBA
  6. Save multiple sheets to .pdf
  7. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  8. How can I create a calendar input in VBA Excel?
  9. Using Google Chrome in Selenium VBA (Installation Steps)
  10. Excel formula to get cell color [duplicate]
  11. Ignore Duplicates and Create New List of Unique Values in Excel
  12. Merge values of column B based on common values on column A
  13. How to use workbook.saveas with automatic Overwrite
  14. How to import a table from web page (with “div class”) to excel?
  15. Range limit conundrum
  16. Using LocationTextExtractionStrategy in itextSharp for text coordinate
  17. How do you run a .exe with parameters using vba’s shell()?
  18. How to determine the last Row used in VBA including blank spaces in between [duplicate]
  19. Passing variable from Form to Module in VBA
  20. How to give a time delay of less than one second in excel vba?
  21. Changing the date format to yyyy-mm-dd
  22. If two cells match, return value from third
  23. Create an Excel File (.xlsx) using PL/SQL
  24. Delete all duplicate rows Excel vba
  25. excel to pdf ignores print area and calls printer
  26. Leave out quotes when copying from cell
  27. Excel Formula to SUMIF date falls in particular month
  28. Select Newest Record and Create New Table of Unique Values in Excel
  29. excel vba freeze pane without select
  30. Converting a string representation of a constant into a constant?

Leave a Comment