Hi all,

I have 2 workbooks, called "review" and "MI" , I need some code that will enable me to enter a value into a cell in "review", and then search "MI" and then pull through the entire row.

IE, enter A12345 into "review", and it then pulls through the entire row from "MI" that matches that reference. enter A12346, it pulls through the row relating to that.

None of the values searched for will ever appear on "MI" more than once, so worrying about duplicates etc shouldn't be a problem.

If it matters, the column it will need to search on "MI" is column D.

If it is also possible to do this without having to have "MI" open, then all the better.

Ultimately I will need it to pull through the information to the "review" workbook, have the user update some more information, then overwrite the info in "MI" in the same place as before.

I'd appreciate it even if someone can at least point me in the right place to start.

Many thanks in advance.