software

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'!A2lt;gt;quot;quot;,'Sheet2'!A2,quot;quot;). I need to copy that formula into
Sheet1: U15 as =IF('Sheet2'!A3lt;gt;quot;quot;,'Sheet2'!A3,quot;quot;) and into Sheet1: U28 as
=IF('Sheet2'!A4lt;gt;quot;quot;,'Sheet2'!A4,quot;quot;) and so on.

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

Assuming that your cells increment consistantly (U2, U15, U28, U41, U54, U67,
etc...), you could use this:

=IF(OFFSET(Sheet2!$A$2,(ROW()-2)/13,0)lt;gt;quot;quot;,OFFSET(Sheet2!$A$2,(ROW()-2)/13,0),quot;quot;)

HTH,
Elkarquot;Josh O.quot; wrote:

gt; I am creating a continuous form to use to print data from another
gt; spreadsheet. What I need to do is copy a formula to paste various cells on a
gt; spreadsheet. For example in Sheet1: U2 I have the following formula:
gt; =IF('Sheet2'!A2lt;gt;quot;quot;,'Sheet2'!A2,quot;quot;). I need to copy that formula into
gt; Sheet1: U15 as =IF('Sheet2'!A3lt;gt;quot;quot;,'Sheet2'!A3,quot;quot;) and into Sheet1: U28 as
gt; =IF('Sheet2'!A4lt;gt;quot;quot;,'Sheet2'!A4,quot;quot;) and so on.
gt;
gt; Is there a simpler way to do that than manually correcting each formula?