Create Filters for a Table based on what is visible in another table

Hello.

I have a workbook which contains many query tables, each table on a separate tab.
Each table shows different field names - but the left most field is the same on all tables (job ID).


The first table (leftmost tab) is special - what I want is some method of filtering all the individual worksheets based on what is visible on the leftmost worksheet. The users will be filtering on this special, left-most-tab, and I don't want them to have to filter on every worksheet.

...the thing is I can't just pass the filters because the user will most definitely not be filtering on the Job ID column and the other columns are quite different...

So, what tried to do is the following event macro (in the attached example this event is triggered when you select the second worksheet labeled "Next Query").

Please Login or Register  to view this content.

The variable "Keep List" is being created exactly as I want, but when I run the last command (which is currently commented out in the code) the result is that everything is de-selected and the table is 'blanked out'.

I'm building the list for the "Criteria1:=" wrong, but i can't see what is happening.

Any ideas would be greatly appreciated.

Figured it out... you have to build the "keepList" as an array, not a string that you attempt to use as an array....

Please Login or Register  to view this content.