Hi guys!

I know it’s pretty easy to run a standard Access query/ macro from Excel. But what if I want an Access query to filter on a value from Excel cell (s)? For example I want to be able to list Customer Names in Excel Range (“A1”).Cells and have it run Access Macro so “Customer” field in Access queries filter on Excel Range (“A1”).Cells values? Is this possible? If it is, can wild characters like * be used?
I am posting this in Excel part of the forum because I am hoping to come up with a Code from Excel side, but if it easier to start it from the Access side, where Access finds Excel file and gets the values from there, I would very appreciate help too.

Thanks a lot for any advice!