add missed digits,letters & symbols , bold and highlight for two sheets based on another

Alaa mg

Active Member
Joined
May 29, 2021
Messages
343
Office Version
  1. 2019
hi
I have two sheets (sheet1,2) with different data structure . the sheet1 should match the column B with sheet MAIN into column B and add missed items into sheet1 . as to sheet2 should match columns B,C,D with sheet MAIN into column B and add missed items also should be bold and highligted by red for the missed items . and I want replace the data when add new data into two sheets(sheet1,2).
the data before
sheet MAIN
zz.xlsx
B
1brand
2CC 2500M14 TT 11TM NN1 GER
3CC 2500M14 13TM TN T123 GER
4CC 2500M14 11TM T123 TN GER
5CC 2500M14 11TM NN1 TT GER
6BBW 1248-23 TL-ML 13TR NN IT
7FG 12456TR40***** 22TM TT 1445V IT
8DF 125/22MT23.5-22TM SL200 GER
9MLC 111MR12L 12TM TD SV123 IT
10NN 123/34T22.5-12MR SS1/1 NN GR
11CC 2500M14 12TA T123 TN GER
MAIN



SHEET1
zz.xlsx
B
1BRAND
2CC 2500M14 11TM NN1 GER
3BBW 1248-23 TL-ML 13TR NN IT
4FG 12456TR40***** 22TM 1445V IT
5DF 125/22MT23.5 SL200 GER
6MLC 111MR12L 12TM SV123 IT
7NN 123/34T22.5 SS1/1 NN GR
8CC 2500M14 11TM NN1 GER
9CC 2500M14 T123 GER
10CC 2500M14 11TM T123 GER
SHEET1


SHEET2
zz.xlsx
BCD
1BRANDTYOR
2CC 2500M14 11TM T123GER
3CC 2500M14 11TM NN1 GER
4BBW 1248-23 TL-ML 13TR NNIT
5FG 12456TR40 1445V 22TM IT
6DF 125/22MT23.522TM ML-120SL200GER
7MLC 111MR12L 12TM SV123IT
8NN 123/34T22.512MR SS1/1 NNGER
9CC 2500M14 11TM NN1GER
10CC 2500M14 T123 GE
SHEET2




after
sheet1 based on sheet MAIN
[
zz.xlsx
B
1BRAND
2CC 2500M14 TT 11TM NN1 GER
3BBW 1248-23 TL-ML 13TR NN IT
4FG 12456TR40***** 22TM TT 1445V IT
5DF 125/22MT23.5-22TM SL200 GER
6MLC 111MR12L 12TM TD SV123 IT
7NN 123/34T22.5-12MR SS1/1 NN GR
8CC 2500M14 13TM TN T123 GER
9CC 2500M14 11TM T123 TN GER
10CC 2500M14 11TM NN1 TT GER
SHEET1



sheet2 based on sheet MAIN
zz.xlsx
BCD
1BRANDTYOR
2CC 2500M14 TT 11TM NN1GER
3CC 2500M14 12TA T123 TNGER
4BBW 1248-23 TL-ML 13TR NNIT
5FG 12456TR40***** 1445V 22TM TT IT
6DF 125/22MT23.5-22TM ML-120SL200GER
7MLC 111MR12L 12TM TD SV123IT
8NN 123/34T22.5-12MR SS1/1 NNGER
9CC 2500M14 11TM TN T123GER
10CC 2500M14 11TM NN1 TTGER
SHEET2

I hope some body help
 
Last edited:

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Forum statistics

Threads
1,212,099
Messages
6,105,957
Members
447,986
Latest member
dicklim39

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