I am using Excel 2010. I have formulas in cells A1:P1. I would like to have a macro copy those formulas to the number of rows below row 1 that is expressed in cell Q1. Q1 has a formula that counts the number of cells in another range that have numeric values.
Example: Q1=10, the macro should copy the formulas in row 1 from row 1 to row 10.