Guys,
Need help on the following for creating a VBA code,
Need to lookup a value from "Sheet B" (column "B") and retrieve the value in "Column C". The lookup value should match the first three digits of a sixteen digit long number (every number has either "0" or "00" so the code is with the zero as well) in "Sheet A" (Column "I") and update the value in the "Sheet A" (column "D"). The matching should be done in row wise in Sheet A
"Sheet A"
Column I - 0440201000018489 (match the first three digits in this no. : "044")
Column D - Update the value in this column (row wise) if above matches the value in "Sheet B" (column "B")
"Sheet B"
Column B - Should lookup the value "044" in this column and update the value in "Column C" in to the "Column D" in Sheet A, if matches
Need help on the following for creating a VBA code,
Need to lookup a value from "Sheet B" (column "B") and retrieve the value in "Column C". The lookup value should match the first three digits of a sixteen digit long number (every number has either "0" or "00" so the code is with the zero as well) in "Sheet A" (Column "I") and update the value in the "Sheet A" (column "D"). The matching should be done in row wise in Sheet A
"Sheet A"
Column I - 0440201000018489 (match the first three digits in this no. : "044")
Column D - Update the value in this column (row wise) if above matches the value in "Sheet B" (column "B")
"Sheet B"
Column B - Should lookup the value "044" in this column and update the value in "Column C" in to the "Column D" in Sheet A, if matches