Formula Fill help

J

Josh O.

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?
 
E

Elkar

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)<>"",OFFSET(Sheet2!$A$2,(ROW()-2)/13,0),"")

HTH,
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top