I got 2 sheet data, and need to combine on the basic of those numbers
(001..002..003..004....)
example: from data-2 "002 TA" match with data-1 "002" and will auto insert
"TA"to next column(**) of data-1 "002"

DATA-1 DATA-2
002 [**] 001 FA
003 [**] 002 TA
006 [**] 003 RT
008 [**] 004 FW
009 [**] 005 DV
006 AG
007 HE
008 PO
009 HW


too large amount, any macro auto for this?
thanks