PDA

View Full Version : VBA to update a table from another table



modiria50989
08-11-2017, 12:03 PM
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
08-11-2017, 03:11 PM
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
08-29-2017, 03:41 PM
Cross-posted at: https://www.mrexcel.com/forum/excel-questions/1018623-update-table-based-another-table.html
Please read VBA Express' policy on Cross-Posting in item 3 of the rules: http://www.vbaexpress.com/forum/faq.php?faq=new_faq_item#faq_new_faq_item3