Hello All, this is my first post here. I hope to explain my question properly. 
I need to run a Macro on a column. 
The cell should display a name. This name is linked to an order number. 
When I pull the report, sometimes the name is missing but I have another sheet matching all names with order numbers. 
So my idea is the following, If the cell is blank, I want to get the name from another sheet using the order number as a reference. 
IF the cell is not blank, then nothing is required as the name is already there. 
The name should be displayed in column B, and the order number is in column C. 
any help is much appreciated. 
Thanks in advance. 

​Hello All, this is my first post here. I hope to explain my question properly. I need to run a Macro on a column. The cell should display a name. This name is linked to an order number. When I pull the report, sometimes the name is missing but I have another sheet matching all names with order numbers. So my idea is the following, If the cell is blank, I want to get the name from another sheet using the order number as a reference. IF the cell is not blank, then nothing is required as the name is already there. The name should be displayed in column B, and the order number is in column C. any help is much appreciated. Thanks in advance.   Read More

​