Hi,
I have about 100 sheets and I want to enter a start date in the Fourth sheet in cell B1. If I enter a formulae (eg. =Sheet4!B1+1) in fifth sheet by grouping all other sheets it should have a relative reference to the previous sheet and add one day in the subsequent sheet. Is it possible with formulae.
Any help please.
I have about 100 sheets and I want to enter a start date in the Fourth sheet in cell B1. If I enter a formulae (eg. =Sheet4!B1+1) in fifth sheet by grouping all other sheets it should have a relative reference to the previous sheet and add one day in the subsequent sheet. Is it possible with formulae.
Any help please.