I am creating a continuous form to use to print data from another
spreadsheet. What I need to do is copy a formula to paste various cells on a
spreadsheet. For example in Sheet1: U2 I have the following formula:
=IF('Sheet2'!A2<"",'Sheet2'!A2,""). I need to copy that formula into
Sheet1: U15 as =IF('Sheet2'!A3<"",'Sheet2'!A3,"") and into Sheet1: U28 as
=IF('Sheet2'!A4<"",'Sheet2'!A4,"") and so on.

Is there a simpler way to do that than manually correcting each formula?