Advanced Filter

[snjpverma]

If I put "East" Under the shops in my Output sheet, then all the rows which contains "East' in the Reference sheet should get pulled up. The problem is that Shops column contains input like this "East, West and North", "East and South". It would have been easier for me to extract data through Advanced Filter if the East or West or north were put Individually.
Also, some cells are Blank, these blanks are always meant to be pulled if the other criteria meet.
Please suggest how to do this.
Let me know if more clarification is needed.


Secondly I am looking for a macro for this; not manually. Thanks

the Data that I want to extract in the Output sheet is from Column D to Column H


Ouput sheet

	A	B	C	D
1	Shops	Type	Product
2	East	XY	Mango
3
4
5
6
7
8
9
10
11
12
13
14

<tbody>
</tbody>

Reference Sheet

	A	B	C	D	E	F	G	H
1	Shops	Type	Product	Quantity	Other data	Other data	Other data	Other data
2	East	AB	Mango	205
3			Apple	659
4	North and South	XY	Grape	887
5	South		Mango	362
6	West	HI	Apple	774
7		AB	Grape	718
8	East, West and North	CD	Mango	964
9	East and South		Apple	530
10	West and East	AB	Grape	417
11
12
13
14

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4