Input variables into contents of cells

[mcfurlong1]

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

[MarvinP]

Hi mcfurlong and welcome back to this forum,

If you have the newer version of Excel and a tool called Power Query or Get & Transform then it will connect to your SQL data. I believe you are asking to have Excel as the filter for your SQL query. I don't have the whole answer but this should start your learning...
https://support.microsoft.com/en-us/...rs=en-us&ad=us

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As this is only your second post, I will provide the link for you this time.)

https://www.mrexcel.com/board/thread...cells.1129816/

[mcfurlong1]

Apologies, did not know that was a rule. Just trying to get some help!

[AliGW]

Of course! This is a help forum and you are not being denied help. However, all forums have rules, in fact the other forum where you posted this has the same cross-posting rule that we do.

There's a link to our rules at the top of the page in the menu bar - you did agree to them when you joined. We've made them super simple and short, so please take a moment to read them through. Thanks.