Hi
I have a data sheet sheet 1 which data is continously updated in columns G, H, I
But however, am looking dynamic formula for column G,H,I for the second sheet as below expected results
That is each time data is entered on sheet 1 it update the whole data in sheet 1 in sheets2 dynamically paticularly column G H I as criteria
Can anyone help
thanks
sheet 1
<colgroup><col><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>
Expected results sheet2 dynamic
<colgroup><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>
I have a data sheet sheet 1 which data is continously updated in columns G, H, I
But however, am looking dynamic formula for column G,H,I for the second sheet as below expected results
That is each time data is entered on sheet 1 it update the whole data in sheet 1 in sheets2 dynamically paticularly column G H I as criteria
Can anyone help
thanks
sheet 1
PO | Inv | Page | Line | Ref | Description | H.CODE | Description_1 | Origin | Qty | U.P | Total |
10A | 1253 | P1 | 1 | 41272019 | CANAILLOU CROQ.MIX VOLAILL400G | 16055100 | MOLLUSCS PREPARATION | GB | 10 | 0.25 | 2.5 |
50AS | 36 | P1 | 1 | 41272059 | CANAILLOU CROQ.CHAT ADULT1.5K | 16055100 | MOLLUSCS PREPARATION | aa | 20 | 10 | 200 |
2ASDR | 25899 | P1 | 1 | 41272060 | CANAILLOU CROQ.CHAT LIGHT1.5KG | 19059090 | SNACK PREPARATIONS | US | 50 | 0.02 | 1 |
0A26DR6 | AB25 | P1 | 1 | 41272061 | CANAIL CROQ.CHAT INTERIEUR1.5K | 20059900 | PRESERVED MIX VEGETABLES | FR | 3 | 10 | 30 |
50BB | 02545A | P1 | 2 | 41272088 | CANAILLOU CROQ MIX VOLAILL 2KG | 20059900 | PRESERVED MIX VEGETABLES | US | 5 | 50.214 | 251.07 |
50BB | 02545A | P1 | 3 | 41103160 | TOP BUDGET PUREE NATURE 500 G | 22021090 | JUICES | ZA | 58 | 33 | 1914 |
50BB | 02545A | P1 | 4 | 41104010 | ST ELOI COUSCOUS MOYEN ET.500G | 20086000 | CHERRIES | IN | 60 | 2 | 120 |
50BB | 02545A | P2 | 1 | 17277385 | PAQUIT POCK PM PRUNO 4X90G SSA | 20089900 | FRUITS IN SYRUP | IN | 55 | 6.6 | 363 |
50BB | 02545A | P2 | 2 | 17277386 | PAQUIT POCK PM MANG 4X90G SSA | 21039090 | MIXED CONDIMENTS | NZ | 478 | 5.5 | 2629 |
50BB | 02545A | P2 | 3 | 40221011 | ODYSE SARDINE HUILE/TOURN135G | 21069070 | DRINKING PREPARATIONS | US | 3 | 41.3 | 123.9 |
0012555A | CC15SEW | P1 | 1 | 40242030 | C.LEGER CASSOULET 840 G | 21069090 | SWEETENERS | FR | 52 | 100 | 5200 |
0012555A | CC15SEW | P1 | 2 | 41033273 | PDT CAPPU.CHOCO BTE306G+7GCHOC | 22021090 | JUICES | DE | 10 | 125.36 | 1253.6 |
0012555A | CC15SEW | P1 | 3 | 41044005 | CHABRIOR CORN FLAKES 375G | 20081900 | POPCORN | DE | 6 | 1254 | 7524 |
ABCFER1A | 25469666 | P1 | 1 | 41044201 | CHABRIOR CROKAWAK 375G | 20081900 | POPCORN | AU | 8 | 2 | 16 |
ABCFER1A | 25469666 | P1 | 2 | 41044501 | CHABRIOR FORME ET CHOCOLAT300G | 20081900 | POPCORN | PT | 11 | 256 | 2816 |
ABCFER1A | 25469666 | P1 | 3 | 41111060 | FIORINI TORTI CELLO 500GR | 20081900 | POPCORN | ES | 52 | 20.3 | 1055.6 |
ABCFER1A | 25469666 | P2 | 1 | 41111070 | FIORINI SPAGHETTI CELLO 500G | 9109991 | CURRY POWDERS | ES | 52 | 78.69 | 4091.88 |
ABCFER1A | 25469666 | P2 | 2 | 0016812 | CARRELET PIN SANS NOEUDS 2000 15 | 9109991 | SPICE HERBS | IT | 44 | 30 | 1320 |
ABCFER1A | 25469666 | P2 | 3 | 0016820 | TASSEAU PIN SANS NOEUDS 2000 15/25 | 9109991 | SPICE HERBS | PL | 96 | 222 | 21312 |
ABCFER1A | 25469666 | P2 | 4 | 0016847 | TASSEAUX BRUT PIN 2000 15/27 | 2101900 | FROZEN MEATS | FR | 3 | 12.698 | 38.094 |
data | data | data | data | data | data | data | data | data | |||
data | data | data | data | data | data | | data | data | data |
<colgroup><col><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>
Expected results sheet2 dynamic
Inv | Page | Line | Ref | Description | H.CODE | Description_1 | Origin | Qty | U.P | Total |
25469666 | P2 | 4 | 0016847 | TASSEAUX BRUT PIN 2000 15/27 | 2101900 | FROZEN MEATS | FR | 3 | 12.698 | 38.094 |
25469666 | P2 | 1 | 41111070 | FIORINI SPAGHETTI CELLO 500G | 9109991 | CURRY POWDERS | ES | 52 | 78.69 | 4091.88 |
25469666 | P2 | 2 | 0016812 | CARRELET PIN SANS NOEUDS 2000 15 | 9109999 | SPICE HERBS | IT | 44 | 30 | 1320 |
25469666 | P2 | 3 | 0016820 | TASSEAU PIN SANS NOEUDS 2000 15/25 | 9109999 | SPICE HERBS | PL | 96 | 222 | 21312 |
1253 | P1 | 1 | 41272019 | CANAILLOU CROQ.MIX VOLAILL400G | 16055100 | MOLLUSCS PREPARATION | GB | 10 | 0.25 | 2.5 |
36 | P1 | 1 | 41272059 | CANAILLOU CROQ.CHAT ADULT1.5K | 19059090 | SNACK PREPARATIONS | CN | 20 | 10 | 200 |
25899 | P1 | 1 | 41272060 | CANAILLOU CROQ.CHAT LIGHT1.5KG | 19059090 | SNACK PREPARATIONS | US | 50 | 0.02 | 1 |
AB25 | P1 | 1 | 41272061 | CANAIL CROQ.CHAT INTERIEUR1.5K | 20059900 | PRESERVED MIX VEGETABLES | FR | 3 | 10 | 30 |
02545A | P1 | 2 | 41272088 | CANAILLOU CROQ MIX VOLAILL 2KG | 20059900 | PRESERVED MIX VEGETABLES | US | 5 | 50.214 | 251.07 |
25469666 | P1 | 1 | 41044201 | CHABRIOR CROKAWAK 375G | 20081900 | POPCORN | AU | 8 | 2 | 16 |
CC15SEW | P1 | 3 | 41044005 | CHABRIOR CORN FLAKES 375G | 20081900 | POPCORN | DE | 6 | 1254 | 7524 |
25469666 | P1 | 3 | 41111060 | FIORINI TORTI CELLO 500GR | 20081900 | POPCORN | ES | 52 | 20.3 | 1055.6 |
25469666 | P1 | 2 | 41044501 | CHABRIOR FORME ET CHOCOLAT300G | 20081900 | POPCORN | PT | 11 | 256 | 2816 |
02545A | P1 | 4 | 41104010 | ST ELOI COUSCOUS MOYEN ET.500G | 20086000 | CHERRIES | IN | 60 | 2 | 120 |
02545A | P2 | 1 | 17277385 | PAQUIT POCK PM PRUNO 4X90G SSA | 20089900 | FRUITS IN SYRUP | IN | 55 | 6.6 | 363 |
02545A | P2 | 2 | 17277386 | PAQUIT POCK PM MANG 4X90G SSA | 21039090 | MIXED CONDIMENTS | NZ | 478 | 5.5 | 2629 |
02545A | P2 | 3 | 40221011 | ODYSE SARDINE HUILE/TOURN135G | 21069070 | DRINKING PREPARATIONS | US | 3 | 41.3 | 123.9 |
CC15SEW | P1 | 1 | 40242030 | C.LEGER CASSOULET 840 G | 21069090 | SWEETENERS | FR | 52 | 100 | 5200 |
CC15SEW | P1 | 2 | 41033273 | PDT CAPPU.CHOCO BTE306G+7GCHOC | 22021090 | JUICES | DE | 10 | 125.36 | 1253.6 |
02545A | P1 | 3 | 41103160 | TOP BUDGET PUREE NATURE 500 G | 22021090 | JUICES | ZA | 58 | 33 | 1914 |
<colgroup><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>