Hello everyone,
New to this and looking for some advice around a sheet I have running.
I run 3 teams who enter their monthly returns in a different sheets which then feed into a main over excel workbook i can open and see everything in one place as an overview and as monthly returns.
My question is in regards to the separate month tabs i have for monthly returns, is there a way that i can say set the Jan month return tab to only update the data from the formulas between the 1st Jan and 31st jan and then stop. and then so on for feb tab march tab etc etc
I then want to at the end of the year stop all formula working, however i do want to be able to copy my workbook so i can use it again in the new year.
sorry loads of info there but this is the last bit
or alternatively is there a way i can go on and enter say the 31/01/2021 into a cell and have the worksheet stop updating as we move to the new month?
New to this and looking for some advice around a sheet I have running.
I run 3 teams who enter their monthly returns in a different sheets which then feed into a main over excel workbook i can open and see everything in one place as an overview and as monthly returns.
My question is in regards to the separate month tabs i have for monthly returns, is there a way that i can say set the Jan month return tab to only update the data from the formulas between the 1st Jan and 31st jan and then stop. and then so on for feb tab march tab etc etc
I then want to at the end of the year stop all formula working, however i do want to be able to copy my workbook so i can use it again in the new year.
sorry loads of info there but this is the last bit
or alternatively is there a way i can go on and enter say the 31/01/2021 into a cell and have the worksheet stop updating as we move to the new month?