Please refer the attachment. I need to populate data in sheet A from B. Values in Coloum B and C (Sheet A) are references with Coloum B and K (Sheet B)
If i need to populate actual units in coloum H (sheet A) from coloum M (sheet B) with reference to coloums B&C (sheet A) and coloums B&K (sheet B), the logic should be like
if values from B & C (Sheet A) are equal to B & K (sheet B) then H becomes equal to M.
These files i have to update each week and its a big file with 1000 rows , can anyone tell me how to code this logic.
Thanks
Vivek
Bookmarks