Vlookup or alternative in VBA

I'm Having 2 files, master.xlsx and price.xlsx

whenever i'm changing in the master file, it have to replace in the price file, like Vlookup.
Eg: in the masterfile, ColumnA: Apple, ColumnB: 10.00.
in the price file, same as ColumnA: Apple, ColumnB: 10.00.
if i change the price of apple in master file, it have to replace in the price.xlsx

i'm having 10000 rows (currently using Vlookup formula, but it is getting slow my excel file), can anyone help me for in VBA coding..

Nick's picture

you could benefit from

you could benefit from changing the way you use Excel..
... is it possible to hold data in one sheet, then Master and Price are pivot table summaries of the data ?