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 function 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