Hello!
I'm trying to make a file that displays at a glance the calendar of activities of the current week.
I have one 'master' sheet that has all my compiled calendar data (columns are date, day, holidays, leave, development, marketing, etc). Then on my second sheet I've copied and pasted the following formula in every cell: =IF(MASTER!A1="","",MASTER!A1) to avoid 0s on blanks. Then I applied a filter to show just the week, and then I plan to lock that sheet so data is entered on the master sheet only.
Is there a way to make the second sheet copy the master sheet's formatting? Or is there a simpler solution to all of this that I've overcomplicated?
I'm trying to make a file that displays at a glance the calendar of activities of the current week.
I have one 'master' sheet that has all my compiled calendar data (columns are date, day, holidays, leave, development, marketing, etc). Then on my second sheet I've copied and pasted the following formula in every cell: =IF(MASTER!A1="","",MASTER!A1) to avoid 0s on blanks. Then I applied a filter to show just the week, and then I plan to lock that sheet so data is entered on the master sheet only.
Is there a way to make the second sheet copy the master sheet's formatting? Or is there a simpler solution to all of this that I've overcomplicated?