Query Data from a Sheet

M

Ming Shao

Hi,

I need to query data from a reference table.

I have a reference sheet and users need to input certain
information, and to query certain data from this
reference sheet. The functionality is like a SQL. My
question is how to write a query in Excel VBA? Can I
define this reference sheet as a table and query it in
VBA code?

Thanks

Ming
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Query Data from a Sheet 4
Append Crosstab Query to Existing Table 0
Data consolidation 0
Help creating a search form in Access XP 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Adding data to MS Access from csv file 0
Dates In Excel 5

Top