macro for 5000 rows for subtraction two columns between two sheets

Hasson

Active Member
Joined
Apr 8, 2021
Messages
406
Office Version
  1. 2016
Platform
  1. Windows
Hi
I want matching column B for sheet1 with column B:D for sheet2 and should subtract the column E,F for sheet2 from the columns C,D for sheet1 for about 5000 rows and if there is new item in sheet1 then should add to sheet2 as in last row
the result should be in column G,H
DIFFERENT VALUES.xlsm
ABCD
1ITEMIDINPUTOUTPUT
21TT/W-1 MM CLA1 23M-1 IT500
32QQW-2 TH NM-1 CLA2 VBG L CHI10
43QQW-3 CV CLA3 TAI700
54QQW-4 M*12.5 CLA4 TR20012
65QQW-5 CLA5 EG300
7MMR12/100 AS-1000/1 TMR12
86QQW-6 M230 TU
97QQW-7 S** CLA7 US14001
108QQW-8 CLA8 UK15001
119QQW-9 CLA9 N BR16001
1210QQW-10 BN CLA10 IT800
1311QQW-11 LVD CH900
1412BB12 QQW-12 CLA12 JA100011
1513QQW-13 CLA13 TR110011
1614QQW-14 L/R CLA14 SS230 EG1200
1715QQW-15 CLA15 TU1300
1816QQW-16 CLA16 US17001
1917QQW-17 CLA17 UK1800
2018QQW-18 RRSDF BR1900
2119QQW-19 CLA19 IT2000
2220QQW-20 KV/1**2 CLA20 CHI2100
sheet1


DIFFERENT VALUES.xlsm
ABCDEFGH
1ITEMIDDESCIBEPRODUCTION BYINPUTOUTPUTINPUTOUTPUT
21QQW-4 M*12.5CLA4TR2001200
32QQW-5CLA5EG50-2500
43QQW-6M230TU00
54TT/W-1 MMCLA1 23M-1IT200-3000
65QQW-2 TH NM-1CLA2 VBG LCHI1000
76QQW-3 CVCLA3TAI10-6900
87QQW-13CLA13TR800-30011
98QQW-14 L/RCLA14 SS230EG900-3000
109QQW-15CLA15TU100011-300-11
1110QQW-7 S**CLA7US80011-600-10
1211QQW-8CLA8UK850-650-1
1312QQW-9CLA9 NBR1000-600-1
1413QQW-10 BNCLA10IT2501-5501
1514QQW-11LVDCH2001-7001
1615BB12 QQW-12CLA12JA11001-100-10
1719QQW-16CLA16US1700100
1820QQW-17CLA17UK180000
1921QQW-18RRSDFBR190000
2022QQW-19CLA19IT200000
2123QQW-20 KV/1**2CLA20CHI210000
2223MMR12/100 AS-1000/1TMR0-12
sheet2
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Forum statistics

Threads
1,224,814
Messages
6,181,120
Members
453,021
Latest member
Justyna P

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