Many thanks to those who can help this one!
Suppose
cell D2 contains formula '=Guardian!B59'
cell B8 contains formula '=Guardian!B59'
cell B21 contains formula '=Wealth!B59'
cell B35 contains formula '=Growth!B59'
Each day I have to go into these formula and Add 1 to them so that thay become
cell D2 contains formula '=Guardian!B60'
cell B8 contains formula '=Guardian!B60'
cell B21 contains formula '=Wealth!B60'
cell B35 contains formula '=Growth!B60'
The following day B61 so on so on..
Is there a quicker way to do so?
Suppose
cell D2 contains formula '=Guardian!B59'
cell B8 contains formula '=Guardian!B59'
cell B21 contains formula '=Wealth!B59'
cell B35 contains formula '=Growth!B59'
Each day I have to go into these formula and Add 1 to them so that thay become
cell D2 contains formula '=Guardian!B60'
cell B8 contains formula '=Guardian!B60'
cell B21 contains formula '=Wealth!B60'
cell B35 contains formula '=Growth!B60'
The following day B61 so on so on..
Is there a quicker way to do so?