Using VBA for search and input

Hi guys,

I am looking for the following VBA input.
I have a data (ID; ID number) which gets automatically populated in the column “B” and “C”. I am looking for a code which should look for the “IMO” in the column B (i.e. “ID”) and once found, place the corresponding number (stored in the column C as “ID number”) in the column “H”.
Kindly see the attached example and note the way the “IMO” shall get populated; i.e. one by one in line with the respective record stipulated in the column “A” (i.e. input (1,2…).

Thanks and regards,

V

Try

Please Login or Register  to view this content.