I want to link the sums from one sheet to another.
In the first sheet the sums are in the rows. I want to link them so when i copy my formulas through columns in the first sheet it refers to the rows in second sheet.
I've been trying this on cell L6, ='sheet2'!T31
Now i want cell M6 to be ='sheet2'!T32. But when i copy, it becomes U31.
I see the logic in why my formula dosent work, but i dont know how to fix it.