I've tried this several ways, but no success so far. Is it possible to pass multiple values from an Excel cell as parameters in a Data query?
In MS Query, this looks like "IN (1,2,3,4,5)". Or, calling a parameter looks like "[List]" which can be tied to one worksheet cell. However, I've not been able to combine the two yet. I also have the need to do the opposite, as in "show me everything but the items in this list." "NOT IN (1,2,3,4,5)"
My primary motivation is to allow someone else to maintain the spreadsheet. Currently, every time the list changes, I need to go into MSQuery and manually maintain it. Since this is a report that ties into our sales compensation verification procedures, I'd prefer that it would be easier for others to update the spreadsheet.
The only solution I've come up with so far is to create multiple parameters in MSQuery tying to multiple individual cells, but I expect this list to have 12 to 20 items. This could be quite cumbersome.
Thanks for any ideas on this. Even if it is to say it's just not possible.