Highlight & copy new items across sheets

KalilMe

Active Member
Joined
Mar 5, 2021
Messages
343
Office Version
  1. 2016
Platform
  1. Windows
Hello

I want matching sheet SH from column B:D with the others sheets for column B if there are new items in others sheets with comparison sheet SH then should highlight by red and copy the highlighted items to sheet RESULT also if I change the highlighted item to become matched then should delete the color .
the data across sheets are about 2000 rows across sheets.
color .xlsm
ABCDE
1ITEMBRTYORSALE
21FRBANANATT300
32FRAPPLELL270
43FRPEARNN60
54FRBANANAQQ70
65VEGTOMATOSS72
76VEGTOMATOAA22
87VEGONIONAA16
sh


color .xlsm
ABC
1ITEMBRSALE
21VEG TOMATO AA22
32VEG ONION AA16
43FR BANANA TT300
54FR BANANA MNB200
SHM


color .xlsm
ABC
1ITEMBRSALE
21FR BANANA TT20
32VEG TOMATO SS10
43VEG TOMATO AA30
54FR BANANA QQ20
65VEG ONION LDS10
MMN



color .xlsm
ABC
1ITEMBRSALE
21FR BANANA MNB200
32VEG ONION LDS10
RESULT


hope some body help .
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Forum statistics

Threads
1,215,219
Messages
6,123,680
Members
449,116
Latest member
HypnoFant

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