Copying formula with the same gap *Edited Post*

[bkcffee]

Hello,
i had to edit this coz the 1st post was too confusing i guess :P

the attachment has 2 sheets,
my work on the 2nd sheet,
it has totals linked with the 1st sheet,
when i copy/paste the table, the formula is not paste as the same gap that i want

please check the Yellow cells in the 2nd Sheet


thanks in advance

[bkcffee]

Bump.... xD

[Bo_Ry]

I would put it in column wise. and just copy the Sheet 2 A44:D46 to F44 and J44

[bkcffee]

I like wt u did there,
but sadly i cant submit it like that...

*Manger mentality issue*


wt about =offset?
is there a trick that work with it ?

[kvsrinivasamurthy]

In 2nd Sheet
In B44

Please Login or Register  to view this content.

In B46

Please Login or Register  to view this content.

Then both formula copied other suitable ranges.Pl see file.

[Bo_Ry]

Please try at
B44 drag to D44
=INDEX('1st Sheet'!B:B,INT((ROW()-1)/46)*41-5+MOD(ROW()+45,46))

B46
=INDEX('1st Sheet'!B:B,INT((ROW()-1)/46)*41-5+MOD(ROW()+45,46))+B40

copy B44:D46 to B90 and B136