Skip to Content
Former Member
Sep 18, 2008 at 10:57 AM

Many execution of a query with different selections in the same work book


Hi all,

I have a workbook with one query that show sales of a plant. User can select many plants, but he doesn't like it, too easy. In this way query shows all the plant in the same sheet and he want a sheet for each plant.

The most simply way to do this is making a query for each plant with a filter with the plant as a constant. Then I put all that queries in the workbook. But this is not too smart, right?

Any suggestion?