-
Hi Sam, Yes, that sounds like a lot of effort. Lifting a finger and all... You could code something that retrieves data from the other workbook without using the query editor. Basically an Open-Copy-Paste-Close action would do the trick. A userform could be used to create some flexibility for parameter...
-
Omar Coincidentally, I posted this yesterday . It uses two and a 'between' operator, but will hopefully let you move forward. Let us know if it is still a problem.