Hi Everyone,

Apologies in advance if my terminology is poor at any point.
This might explain why my Google searches for the answer have proved fruitless.

My Excel doc is pointing to an Access database for its data connection.
I have a simple SQL query running in this data connection...

Select * from row WHERE YEAR([Date]) = 2015 OR (YEAR([Date]) = 2014 AND MONTH([Date]) = 12 OR MONTH([Date]) = 11) order by ID asc

Now ideally what i would like to do is use cells in my Excel spread sheet instead of hard coding them into the SQL query.

My Access database has the headers:
Name Date TimeSpent Reason Allowance Supplier AllowanceDate Activity Tier AdsCompleted Country QuoteNo Comments ID

I would like to only return the data for entries in the database where the name appears in a range of cells.

So the SQL brings back any data relating to names in a certain cell range.

A B
1 Tom Good
2 **** Bad
3 Harry Ugly

Does that all make sense?