Dynamic sorting formula from data entry sheet to update sorting sheet 2 automatically for specific columns

RAM1972

Board Regular
Joined
Jun 29, 2014
Messages
217
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

:confused::confused:Can anyone help

thanks
sheet 1
POInvPage LineRefDescription
H.CODE
Description_1
OriginQtyU.PTotal
10A1253P1141272019CANAILLOU CROQ.MIX VOLAILL400G
16055100MOLLUSCS PREPARATIONGB100.252.5
50AS36P1141272059CANAILLOU CROQ.CHAT ADULT1.5K16055100MOLLUSCS PREPARATIONaa2010200
2ASDR25899P1141272060CANAILLOU CROQ.CHAT LIGHT1.5KG19059090SNACK PREPARATIONSUS500.021
0A26DR6AB25P1141272061CANAIL CROQ.CHAT INTERIEUR1.5K20059900PRESERVED MIX VEGETABLES
FR31030
50BB02545AP1241272088CANAILLOU CROQ MIX VOLAILL 2KG20059900PRESERVED MIX VEGETABLESUS550.214251.07
50BB02545AP1341103160TOP BUDGET PUREE NATURE 500 G22021090JUICESZA58331914
50BB02545AP1441104010ST ELOI COUSCOUS MOYEN ET.500G20086000CHERRIESIN602120
50BB02545AP2117277385PAQUIT POCK PM PRUNO 4X90G SSA20089900FRUITS IN SYRUPIN556.6363
50BB02545AP2217277386PAQUIT POCK PM MANG 4X90G SSA21039090MIXED CONDIMENTSNZ4785.52629
50BB02545AP2340221011ODYSE SARDINE HUILE/TOURN135G21069070DRINKING PREPARATIONSUS341.3123.9
0012555ACC15SEWP1140242030C.LEGER CASSOULET 840 G21069090SWEETENERSFR521005200
0012555ACC15SEWP1241033273PDT CAPPU.CHOCO BTE306G+7GCHOC22021090JUICESDE10125.361253.6
0012555ACC15SEWP1341044005CHABRIOR CORN FLAKES 375G
20081900POPCORNDE612547524
ABCFER1A25469666P1141044201CHABRIOR CROKAWAK 375G20081900POPCORNAU8216
ABCFER1A25469666P1241044501CHABRIOR FORME ET CHOCOLAT300G20081900POPCORNPT112562816
ABCFER1A25469666P1341111060FIORINI TORTI CELLO 500GR20081900POPCORNES5220.31055.6
ABCFER1A25469666P2141111070FIORINI SPAGHETTI CELLO 500G9109991CURRY POWDERSES5278.694091.88
ABCFER1A25469666P220016812CARRELET PIN SANS NOEUDS 2000 159109991SPICE HERBSIT44301320
ABCFER1A25469666P230016820TASSEAU PIN SANS NOEUDS 2000 15/259109991SPICE HERBS
PL9622221312
ABCFER1A25469666P240016847TASSEAUX BRUT PIN 2000 15/272101900FROZEN MEATSFR312.69838.094
datadatadatadatadatadata
datadatadata
datadatadatadatadatadata

datadatadata

<colgroup><col><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>

Expected results sheet2 dynamic

Inv
Page LineRefDescription
H.CODE
Description_1OriginQtyU.PTotal
25469666P240016847TASSEAUX BRUT PIN 2000 15/272101900FROZEN MEATSFR312.69838.094
25469666P2141111070FIORINI SPAGHETTI CELLO 500G9109991CURRY POWDERSES5278.694091.88
25469666P220016812CARRELET PIN SANS NOEUDS 2000 159109999SPICE HERBSIT44301320
25469666P230016820TASSEAU PIN SANS NOEUDS 2000 15/259109999SPICE HERBSPL9622221312
1253P1141272019CANAILLOU CROQ.MIX VOLAILL400G16055100MOLLUSCS PREPARATIONGB100.252.5
36P1141272059CANAILLOU CROQ.CHAT ADULT1.5K19059090SNACK PREPARATIONSCN2010200
25899P1141272060CANAILLOU CROQ.CHAT LIGHT1.5KG19059090SNACK PREPARATIONSUS500.021
AB25P1141272061CANAIL CROQ.CHAT INTERIEUR1.5K20059900PRESERVED MIX VEGETABLESFR31030
02545AP1241272088CANAILLOU CROQ MIX VOLAILL 2KG20059900PRESERVED MIX VEGETABLESUS550.214251.07
25469666P1141044201CHABRIOR CROKAWAK 375G20081900POPCORNAU8216
CC15SEWP1341044005CHABRIOR CORN FLAKES 375G20081900POPCORNDE612547524
25469666P1341111060FIORINI TORTI CELLO 500GR20081900POPCORN
ES5220.31055.6
25469666P1241044501CHABRIOR FORME ET CHOCOLAT300G20081900POPCORNPT112562816
02545AP1441104010ST ELOI COUSCOUS MOYEN ET.500G20086000CHERRIESIN602120
02545AP2117277385PAQUIT POCK PM PRUNO 4X90G SSA20089900FRUITS IN SYRUPIN556.6363
02545AP2217277386PAQUIT POCK PM MANG 4X90G SSA21039090MIXED CONDIMENTSNZ4785.52629
02545AP2340221011ODYSE SARDINE HUILE/TOURN135G21069070DRINKING PREPARATIONS
US341.3123.9
CC15SEWP1140242030C.LEGER CASSOULET 840 G21069090SWEETENERSFR521005200
CC15SEWP1241033273PDT CAPPU.CHOCO BTE306G+7GCHOC22021090JUICES
DE10125.361253.6
02545AP1341103160TOP BUDGET PUREE NATURE 500 G22021090JUICESZA58331914

<colgroup><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Forum statistics

Threads
1,215,509
Messages
6,125,216
Members
449,215
Latest member
texmansru47

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top