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