Can I partially mirror a sheet such as columns?
I'm trying to do find a way to automatically share information from one sheet into another sheet and share it. For instance, I want to have a sheet with all the relevant information for the company's events, including budget information. Then, I want to have another sheet mirror most of the same information except budget and some other columns. I would need both sheets to update automatically when the other is modified. When I hide the columns and share the master sheet with the budget columns hidden are still seen.
Therefore, I want to have a master sheet with all the information and then I want a secondary sheet that mirrors the info minus certain rows. Please help.