Finding a cell value in another workbook and copying parent value of it in same sheet

Hi,

The Macro I am working on should only map the cell which has value and should not map the empty cells which are marked YELLOW in sheet "Data"

For e.g.:- Cell B2(NNN) in worksheet "Split Data" maps into cell C4("CCC") in worksheet "Copy of Mapping Details". So if you see in worksheet "Data" cell B2 has the value("CCC") but after that cell C2 to K2 is not empty where it should be empty. The reason that cells C2 to K2 shuod be empty because cells C2 to K2 in worksheet "Split Data" are empty and same follows for all the cells which are empty.

I hope you get this brief understanding and help me in getting the answer. I am attaching the sheets for your refrence. The macro is in the workbook "Copy of Extract" called "Mapping".

Regards,
Pankaj