Insert row based on Value in above cell
 

Hi All,

How can I insert one/more row below one row based on cell value of that row.
Eg, if A1=Yes (drop down with Yes/ No) then I want one row to be added below,
if possible with certain text/message in below added row.

And later if No is selected that row is made hidden/deleted.

Thanks, SS