Home » Forums » Open Source Learning Center » Question and Answer

Vlookup or alternative in VBA

Submitted by hdean80 on 8 February, 2015 - 09:02

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..

‹ VBA Macro to make cell values change to have their SUM always equal 100 A huge data in a particular format in excel is to be added to database ›
»
Nick's picture

you could benefit from

Submitted by Nick on 8 February, 2015 - 09:47.

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 ?

»