Forum Discussion
Solved
dont want Master worksheet updates
Hello. I have a master worksheet for month master. Month Master is copied to 12 sheets named jan , feb, mar....dec. whenever I update a month sheet eg 'jan', the updates are also made in "Month ma...
- Basically Month Master sheet is not being updated. Literally it does what it is meant to. You have created a master file that has some formulas that uses data from seperate sheets. and it is being updated according to the data entered to the related page.
If you want to create a template for pages and workbook what you should do is not saving the template sheet as a seperate master sheet but save the whole file as a template with all the formulas in it but without values. To do this create the file with all the formulas in it. Delete the master sheets and leave only the pages that you need. And then save this file as a template. And whenever you need to open a new file depending on this template you can use File-->New" and select your template which will create an empty workbook with all the formulas you neeed.
However if you need to create the pages seperately when needed you can save the Months master page in a different file and save that file as template and use a macro to create a new page depending on this template.
I have sent you the file sir. please check it.
Your month master sheet has formulas that gets values from seperate month pages. Below you can see the formula taken from the C5 of Month Master
=SUM(Jun!AH5)
The value is directly taken from AH5 cell of Jun sheet. So if you do not want your master month sheet to be updated what do you want to see in this page?
=SUM(Jun!AH5)
The value is directly taken from AH5 cell of Jun sheet. So if you do not want your master month sheet to be updated what do you want to see in this page?
Thanks so much for taking the time to have a look and try to figure it out.
The "Daily Master' sheet is copied to the sheets named as 'Jan' 'Feb', 'Mar'....."Dec'. These are to record entries of each day of the month, specified as columns named 1, 2,3, 4....30 or 31 as the case may be.
The 'Daily master" sheet is a MASTER sheet or 'original format' that I will keep copying for each month of every new year. So this one should not be updated, but still have all the formulas. I've tried copying it to a totally new file, but it also takes references of the old 'CR2018' file.
Similarly, the "Month Master' is a MASTER sheet or 'format' for the "Month" sheet, that has data consolidated from all the jan , feb, ...dec sheets. here again the original sheet is for saving formulas and layouts so as not to repeatedly create this for each year....so it should not be updated.
But both the sheets get updated, that I don't want happening, but Still want to retain them as is (including formulas) to simplify the process of creating copies of them.
Hope this makes the scenario clearer to you.
Thanks.
- Basically Month Master sheet is not being updated. Literally it does what it is meant to. You have created a master file that has some formulas that uses data from seperate sheets. and it is being updated according to the data entered to the related page.
If you want to create a template for pages and workbook what you should do is not saving the template sheet as a seperate master sheet but save the whole file as a template with all the formulas in it but without values. To do this create the file with all the formulas in it. Delete the master sheets and leave only the pages that you need. And then save this file as a template. And whenever you need to open a new file depending on this template you can use File-->New" and select your template which will create an empty workbook with all the formulas you neeed.
However if you need to create the pages seperately when needed you can save the Months master page in a different file and save that file as template and use a macro to create a new page depending on this template.Thanks so much Erol! I understand I will try all of this out and let you know.
Regards.