Forum Discussion
Copying formulas from one cell to the next row down on a worksheet that calculates data from another
I want to copy this down a column so that the cells maintain same logic e.g. (Jan!AI$38-jan!aH$38)+(feb!AI$38-AH!$38)+(Mar!AI$38-Mar!AH$38). I want to copy down one cell on another worksheet so that:...
Let's say the first formula will be in B2. Use
=INDEX(JAN!$38:$38,2*(ROW(B2)-ROW($B$2))+35)-INDEX(JAN!$38:$38,2*(ROW(B2)-ROW($B$2))+34)+INDEX(FEB!$38:$38,2*(ROW(B2)-ROW($B$2))+35)-INDEX(FEB!$38:$38,2*(ROW(B2)-ROW($B$2))+34)+INDEX(MAR!$38:$38,2*(ROW(B2)-ROW($B$2))+35)-INDEX(MAR!$38:$38,2*(ROW(B2)-ROW($B$2))+34)
Then fill down.