I have a requirement to create workbook which will contain 2 queries. Both the queries have same selection criteria i.e. records are filtered based on Customer ID. For this I have designed a custom pop up through which user can enter customer id. Now the requirement is pop up must be displayed once for both the queries and the records get filtered in both the queries.
I have desgined one query and it is working fine but dont know how to satisfy the filter criteria with one pop up for both the queries.
Thanks in advance.