Filter Multiple Tables at once based on Cell value

[Martin sherk]

Hello,

Is there a way I can Filter multiple tables at once based on a specific cell value using VBA.

As you can see I have 4 tables, I want to be able to filter Columns A and B in the 4 tables (Code and Customer) based on Cell H3 Value and I3.

Book1
	A	B		D			G	H	I
1
2							#	Code	Customer
3								A	F
4
5
6	Code	Customer		Reference			Pay	-	*
7	A	F		SALARY			100.00	0.00	-
8	B	G		SALARY			100.00	0.00
9	C	H		SALARY			100.00	0.00
10	D	W		SALARY			100.00	0.00
11	E	S		SALARY			100.00	0.00
12
13
14
15
16	Code	Customer		Reference			Pay	-	*
17	A	F		SALARY			100.00	0.00
18	B	G		SALARY			100.00	0.00
19	C	H		SALARY			100.00	0.00
20	D	W		SALARY			100.00	0.00
21	E	S		SALARY			100.00	0.00
22
23
24
25
26	Code	Customer		Reference			Pay	-	*
27	A	F		SALARY			100.00
28	B	G		SALARY			100.00
29	C	H		SALARY			100.00
30	D	W		SALARY			100.00
31	E	S		SALARY			100.00
32
33
34
35	Code	Customer		Reference			Pay	-	*
36	A	F		SALARY			100.00
37	B	G		SALARY			100.00
38	C	H		SALARY			100.00
39	D	W		SALARY			100.00
40	E	S		SALARY			100.00
Sheet1

 

[alansidman]

Will Code A always refer to Customer F? Or can Code A also refer to other customers?

 

[Martin sherk]

Will Code A always refer to Customer F? Or can Code A also refer to other customers?

hello Sir,

it can refer to other customers as well, that's why i have two filter criteria code and customer.

 

[alansidman]

Can be done in Power Query. Load each table to PQ Editor. Create a parameter query for each of the variables and substitute the parameter for the filter. Close and Load each query to a table.

 

[Martin sherk]

Can be done in Power Query. Load each table to PQ Editor. Create a parameter query for each of the variables and substitute the parameter for the filter. Close and Load each query to a table.

these tables are already coming from PQ, am sorry i didn't get the second part

 

[alansidman]

Here is a MrE tutorial on Parameter Queries