Here i paste one excel report. In this, In need to make a report form a Master data with search keys.. please find the attached file and help me please...
thanks in advance..
<tbody>
</tbody>
<tbody>
</tbody>____
<tbody>
</tbody>_____
<tbody>
</tbody>_____
for reference see the image link : https://ibb.co/kDBGhR
thanks in advance..
Master Data | ||||
Item No. | Name | Code | Price | Cat. |
245 | Apple Red | UK | 1.50 | 10 |
4157 | Orange Naval USA | USA | 1.30 | 11 |
1479 | Glove | hand | 2.00 | 33 |
22 | Apple Green Italy | Italy | 1.20 | 10 |
584 | m. Water | Mineral | 1.00 | 22 |
589961 | Orange Juice500ml | Juice | 1.00 | 15 |
146211 | Drinkeing Water | Bottle | 1.70 | 22 |
58 | Sauce3oz | Sauce | 1.70 | 20 |
8887 | Mix veg | veg | 1.60 | 45 |
4572 | G.Duck | Duck | 3.20 | 46 |
<tbody>
</tbody>
<tbody>
</tbody>
Data | SearchKey | ||
Item No. | Name | ||
245 | Apple Red | Red | |
4157 | Orange Naval USA | usa | |
1479 | Glove | ||
22 | Apple Green Italy | red | |
584 | m. Water | m. | |
589961 | Orange Juice500ml | 500 | |
146211 | Drinkeing Water | drin | |
58 | Sauce3oz | oz |
<tbody>
</tbody>
Reuslt (Cat. Wise) | |||
Name | Code | Price | Cat. |
Apple Red | UK | 1.50 | 10 |
Apple Green Italy | Italy | 1.20 | 10 |
Orange Naval USA | USA | 1.30 | 11 |
Orange Juice500ml | Juice | 1.00 | 15 |
Sauce3oz | Sauce | 1.70 | 20 |
m. Water | Mineral | 1.00 | 22 |
Drinkeing Water | Bottle | 1.70 | 22 |
<tbody>
</tbody>
for reference see the image link : https://ibb.co/kDBGhR
Last edited by a moderator: