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
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]14[/TD]
</tbody>
Reference Sheet
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: right"]205[/TD]
[TD="align: center"]3[/TD]
[TD="align: right"]659[/TD]
[TD="align: center"]4[/TD]
[TD="align: right"]887[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"]362[/TD]
[TD="align: center"]6[/TD]
[TD="align: right"]774[/TD]
[TD="align: center"]7[/TD]
[TD="align: right"]718[/TD]
[TD="align: center"]8[/TD]
[TD="align: right"]964[/TD]
[TD="align: center"]9[/TD]
[TD="align: right"]530[/TD]
[TD="align: center"]10[/TD]
[TD="align: right"]417[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]14[/TD]
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
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 | |
| Shops | Type | Product | ||
| East | XY | Mango | ||
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]14[/TD]
</tbody>
Reference Sheet
| A | B | C | D | E | F | G | H | |
| Shops | Type | Product | Quantity | Other data | Other data | Other data | Other data | |
| East | AB | Mango | ||||||
| Apple | ||||||||
| North and South | XY | Grape | ||||||
| South | Mango | |||||||
| West | HI | Apple | ||||||
| AB | Grape | |||||||
| East, West and North | CD | Mango | ||||||
| East and South | Apple | |||||||
| West and East | AB | Grape | ||||||
<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: right"]205[/TD]
[TD="align: center"]3[/TD]
[TD="align: right"]659[/TD]
[TD="align: center"]4[/TD]
[TD="align: right"]887[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"]362[/TD]
[TD="align: center"]6[/TD]
[TD="align: right"]774[/TD]
[TD="align: center"]7[/TD]
[TD="align: right"]718[/TD]
[TD="align: center"]8[/TD]
[TD="align: right"]964[/TD]
[TD="align: center"]9[/TD]
[TD="align: right"]530[/TD]
[TD="align: center"]10[/TD]
[TD="align: right"]417[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"]14[/TD]
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Last edited:
