VBA to update a table from another table

[modiria50989]

Hello,
I need a VBA for the following process please. Thanks.
If we have 2 tables in excel. each table has different number ofrows, they have 2 columns including car nembers and car names. the macrofirst look at the car number at table 1 then goes through table 2, if finds asame car number, then replace the car name at table 1 with the car name attable 2 corresponding to that car number.

[D_Marcel]

Why not using the formulae VLOOKUP or INDEX(MATCH)? You'd need add a third column in the first table. If find the car in the table 2, then get its name.

[macropod]

Cross-posted at: https://www.mrexcel.com/forum/excel-...her-table.html
Please read VBA Express' policy on Cross-Posting in item 3 of the rules: http://www.vbaexpress.com/forum/faq...._new_faq_item3