I want to pick up data from another excel file "A" (worksheet) when I write a
value in Excel file (B) at specified cell, in this case a four digit number.
Let say that I search data for value "9999". In file "A" there is a row at
column A that contains "9999". Then I would like to add 3 different cell data
from same row as "9999" automatically.
In other words:
When I write "9999" in cell "B5" in file "B" search for value "9999" in
column A=9999 let us say that "9999" is in row A3 in file "A"
I want to import value "D3" to file "B" cell "B6"
I want to import value "E3" to file "B" cell "B7"
I want to import value "F3" to file "B" cell "B8"

Thanks for any ones help! The two files are in the same PC and same directory