How to use Filter Data Table using value from another Excel Workbook?

Let’s say that I want to use Filter Data Table from Excel “A” but, instead of entering a fixed value I wanted to take the value itself from another Excel Workbook (e.g Excel “B”). Is there any ways to achieve this?

Here is a screenshot of my filter configuration so far. You can see that right now I have to enter the Value specifically and I want to take that Value from another Excel Workbook.

Screenshot 2021-10-29 095410


If you want to compare with static value in the another datatable, the following will work, for example.


If you want to use dynamic value such as compare each row, need to use LINQ etc.


1 Like