Excel select a row & copy the formula into next row
 

Hello
I have two questions, how do I select a row from column A to AG then search
for blanks? the row is not always the same row, thanks.
How do I copy the formulas from row 2 to row 3 (columns A to AG only) when I
enter a data in cell A3, thanks heaps.