I have a list of queries that I use rather frequently and the only thing that needs edited in those queries is essentially a list that the query is searching for. An example query is:
Capture1.JPG
I then have a list of Account_numbers on another tab, in column A, in the excel document and I want to know if there is an easy way to have the query list work so it would automatically input the account_account number into the query. I understand I could do a concatenate of the text and do & 'Cells' & sort of thing but I want it to be more functional and also be able to input multiple account numbers, in single quotes, comma separated.
In the end I want the functionality to show the following when there are multiple account_numbers:
Capture2.JPG
Bookmarks