insert row to add new data for each part

leap out

Active Member
Joined
Dec 4, 2020
Messages
288
Office Version
  1. 2016
  2. 2010
Hello
I would match data between two sheets based on matching columns B,C,D together , then should add the values from sheet RES to sheet summary under headers BUYING and SELLING . should add the values to last column (BUYING ,SELLING), if the data in column B,C,D are new, then should match based on column A betweent sheets and insert new row for is relating part based on column A ,each part contains the item into column A in sheet summary from the first row and finish to row contains S.AG , so if any item in column A for sheet res matches with the item in frist row for sheet summary for each part ,then should add new data into this part befor row S.AG and add the values into the last columns contain headers BUYING & SELLING ,because evrey month insert three columns BUYING,SELLING,NET. the most important BUYING,SELLING should match data between two sheets based on columns B,C,D and put the values under headers .
note: about new data I highlighted for two sheets how is in sheet RES and how become in sheet SUMMARY
SUM & ADD (1) (1) (1).xlsm
ABCDEFGHIJKLMNO
1CLASSIFICATIONGOODSMARKMANFACTUREREFRS.NBUYINGSELLINGNETBUYINGSELLINGNETBUYINGSELLINGNET
2OIL-AS210W40 208LCASSURE1RS1000
310W40 208LENIITRE1RS1000
45W30 208LQ8EURE1RS1000
510W40 208LQ8EURE1RS1000
610W40 12x4LQ8EURRM3CV30
7S.AG000000000
8OIL-AS2110W40 12x1LQ8EURM1RC100
910W40 12x1LCASSURM1RC100
1010W40 12x1LENIITRM1RC100
1115W40 12x1LCASSURM1RC100
12S.AG000000000
13MS-OIL15W30 12x1LQ8EURRM1CV1000
1410W40 4x4LQ8EURRM1CV1000
1510W40 4x4LCASSURRM1CV1000
1610W40 4x4LENIITRRM1CV1000
175W40 4x4LQ8EURRM1CV1000
185W40 4x4LCASSURRM1CV1000
195W40 4x4LENIITRRM1CV1000
2020W50 4x4LQ8EURRM1CV110101010
2120W50 4x4LCASSURRM1CV112-12-12-12
2220W50 4x4LENIITRRM1CV1000
235W30 4x4LQ8EURRM1CV1000
24S.AG1012-200-200-2
summary
Cell Formulas
RangeFormula
O13:O23,O8:O11,L13:L23,O2:O5,L2:L5L2=I2+J2-K2
J7:O7,G7:H7G7=SUM(G2:G5)
G12:O12G12=SUM(G8:G11)
I13:I23,I2:I11I2=G2-H2
G24:O24G24=SUM(G13:G23)



SUM & ADD (1) (1) (1).xlsm
ABCDEFGH
1ITEMGOODSMARKMANFACTUREREFRS.NBUYINGSELLING
2OIL-AS2110W40 12x1LQ8EURM1RC110010
3OIL-AS2110W40 12x1LCASSURM1RC16005
4OIL-AS2110W40 12x1LENIITRM1RC1125
5OIL-AS2110W40 208LCASSURE1RS120040
6OIL-AS2115W40 12x1LCASSURM1RC1131
7OIL-AS210W40 208LENIITRE1RS140020
8OIL-AS25W30 208LQ8EURE1RS16020
9MS-OIL120W50 4x4LQ8EURRM1CV110
10MS-OIL120W50 4x4LCASSURRM1CV112
11MS-OIL120W50 4x6LCASSURRM2CV22013
12OIL-AS210W40 12x4LQ8EURRM3CV32014
RES

result in sheet summary
SUM & ADD (1) (1) (1).xlsm
ABCDEFGHIJKLMNO
1CLASSIFICATIONGOODSMARKMANFACTUREREFRS.NBUYINGSELLINGNETBUYINGSELLINGNETBUYINGSELLINGNET
2OIL-AS210W40 208LCASSURE1RS1000
310W40 208LENIITRE1RS140020380380380
45W30 208LQ8EURE1RS16020404040
510W40 208LQ8EURE1RS1000
610W40 12x4LQ8EURRM3CV32014666
7S.AG460404200042000420
8OIL-AS210W40 12x1LQ8EURM1RC110010900
910W40 12x1LCASSURM1RC160055950
1010W40 12x1LENIITRM1RC11251250
1115W40 12x1LCASSURM1RC11311310
12S.AG95615941000000
13MS-OIL15W30 12x1LQ8EURRM1CV1000
1410W40 4x4LQ8EURRM1CV1000
1510W40 4x4LCASSURRM1CV1000
1610W40 4x4LENIITRRM1CV1000
175W40 4x4LQ8EURRM1CV1000
185W40 4x4LCASSURRM1CV1000
195W40 4x4LENIITRRM1CV1000
2020W50 4x4LQ8EURRM1CV110101010
2120W50 4x4LCASSURRM1CV112-12-12-12
2220W50 4x4LENIITRRM1CV1000
235W30 4x4LQ8EURRM1CV1000
2420W50 4x6LCASSURRM2CV22013777
25S.AG1012-200-200-2
summary
Cell Formulas
RangeFormula
O13:O24,O8:O11,O2:O6,L13:L24,L2:L6L2=I2+J2-K2
J7:O7,G7:H7G7=SUM(G2:G5)
G12:O12G12=SUM(G8:G11)
I13:I24,I2:I11I2=G2-H2
G25:O25G25=SUM(G13:G23)
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,636
Latest member
laura12345

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