$$Excel-Macros$$ Replace #N/A with next Valid Data

Hi Experts I have excel data in column *B*. In some cells there is data *#N/A* --> I want to Replace *#N/A* , with data in *next cell.* --> If *#N/A* is in more than 1 cells (continuous) , then Replace them with *next valid data*. --> If there is no Valid data in any next cell, then Replace

$$Excel-Macros$$ Replace #N/A with next Valid Data

Hi Experts I have excel data in column *B*. In some cells there is data *#N/A* --> I want to Replace *#N/A* , with data in *next cell.* --> If *#N/A* is in more than 1 cells (continuous) , then Replace them with *next valid data*. --> If there is no Valid data in any next cell, then Replace