excel macro question - Microsoft Community

hello,

i need vba following process please.

if have 2 tables in excel. each table has diffrent number of rows, have 2 columns including car nembers , car names. macro first @ car number @ table 1 goes through table 2, if finds same car number, replace car name @ table 1 car name @ table 2 corresponding car number.

 

thank you,

ata

there no need macro, can accomplish same simple formula.

e.g. use vlookup in helper column , search number name, in case of error return existing name. drag formula down, copy cells , paste values table.

andreas.

Office / Excel / Windows 8 / Office 2010