Automatic update from different workbook

Hi,

I need to automatic the update of data from a sub-workbook (abc) to the main workbook (consol) by using vba. But, my problem arises when i need to copy the formulae as seen at cell B3 to the rest of the row by excluding if in column A, there is no name in it. But, it will still continue to fill up the rest of the row.

Can anyone help me out with this problem?

Many thanks
Justin

Hi
try =IF(A3<>"",VLOOKUP(A3,'C:\abc\[abc.xls]Sheet1'!$A:$B,2,0),"")
Ravi

Hi,

Thanks for your reply. I have updated the vba code. However, I need move the active cell from B3 to C3 if I select company BCA. How can I do that? Because the company name at row 1 may be a few column away from each other. I need a vba that will locate the company name and move accordingly.

Secondly, I have a vba that read like this:

Range("b3") = "=VLOOKUP(A3,[abc.xls]Sheet1!$A:$B,2,0)"

But, however, I need the cell to vlookup for the data from the company that I selected like BCA because the above function is constant.

I would appreciate if you can enlighten me as I really have no idea of how to go about to do it.

Many thanks
Justin