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.
hope some body help .
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 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | ITEM | BR | TY | OR | SALE | ||
2 | 1 | FR | BANANA | TT | 300 | ||
3 | 2 | FR | APPLE | LL | 270 | ||
4 | 3 | FR | PEAR | NN | 60 | ||
5 | 4 | FR | BANANA | 70 | |||
6 | 5 | VEG | TOMATO | SS | 72 | ||
7 | 6 | VEG | TOMATO | AA | 22 | ||
8 | 7 | VEG | ONION | AA1 | 6 | ||
sh |
color .xlsm | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | ITEM | BR | SALE | ||
2 | 1 | VEG TOMATO AA | 22 | ||
3 | 2 | VEG ONION AA1 | 6 | ||
4 | 3 | FR BANANA TT | 300 | ||
5 | 4 | FR BANANA MNB | 200 | ||
SHM |
color .xlsm | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | ITEM | BR | SALE | ||
2 | 1 | FR BANANA TT | 20 | ||
3 | 2 | VEG TOMATO SS | 10 | ||
4 | 3 | VEG TOMATO AA | 30 | ||
5 | 4 | FR BANANA QQ | 20 | ||
6 | 5 | VEG ONION LDS | 10 | ||
MMN |
color .xlsm | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | ITEM | BR | SALE | ||
2 | 1 | FR BANANA MNB | 200 | ||
3 | 2 | VEG ONION LDS | 10 | ||
RESULT |
hope some body help .