I know how to create a database query from another worksheet.

But can the query be from the SAME worksheet? How is that done?