I was wondering if it is possible for me to have one query in two different sheets with two different filters? For example, in sheet 1, I want the query to give the sales for material A and in sheet 2 the same query results for material B.
I hope I was clear enough. Any ideas on this?
Thanks for your help in advance.