Making a v lookup in VB 追蹤

lidor ben shimol

Hello , im using allot with bartender with Excels Database.

the excels are made from the ERP system that we work with.

The help i need is this, at the excel we add column that contains "code" that take the information like Weight from another excel table

after that we add it to the bartender, the problam is that this action is manual action that we need to do all the time ( the drag and drop ) .

i want to know if its possible to make a "text" that take the info form the excel that contain this information by VB?