vba to Copy entire rows append to another workbook if Vlookup match

(column use text-to-column to format general before vlookup on all lookup column)

Hi i like to do this by Vlookup macro to copy out entire rows for matching. After that delete row.

Vlookup concat 2 columns for lookup range and value.

Thank you.