I have two nonshared workbooks that need to be merged Wk bk 3 into wb 1 after
comparing Here's content from them:
Workbook 1

FIRM_NO FLEET_NO UNIT_NO Renewed PLATE_NO AXLES VEH_MAKE
7206 1 526311C Y P00438585 2 FRTL
7206 1 90478A Y P00417552 3 INTH
7206 1 525777A Y P00467280 5 WHGM

Workbook 2

FIRM_NO FLEET_NO UNIT_NO PLATE_NO VEH_MAKE
7206 1 739 P00023374 KW
7206 1 756 P00022115 KEN
7206 1 2545 P00023385 INTL