How do I reference a cell in another sheet using a formula.
On sheet 1 I have a daily finance record with a weekly total. On sheet 2 is weekly. On sheet 3 is monthly.
On sheet 2 I want to reference the total I have on sheet 1 of the weekly total. Column A has week count.
So I want to use something like :
So B1=+$Daily.C7, B2=+$Daily.C14 etc
Is this possible ?