excel.jpg

I want to search the word "no" from P1 to AD23 and display the results in rows R32,R33,R34 and so on depending upon results. Please help.