conditional query
 

Dear All,

I have a big file in which I have the records of above 100 suppliers.
thats why I prepared a query in which i can gather my required
supplier all data but for this purpose i have to prepare so many
queries.

So, I need a query that will be start from cell A2 and it take the
supplier name from A1. it means that when I change supplier name is A1
and refresh data then it will show new suppliers records.

Thnx