Hello,
Can ONE create three additional tabs from existing tab that look exactly the same. Instead of copying them I would like to have the existing sheet be the master so all changes on that tab, will automatically update the other tabs.
Let me explain the purpose and end result:
I would like to use the existing tab to change the revenue. The second, third and fourth tabs will have columns and rows hidden so that I will make them presentable for committee meetings. Since this information will change frequently I want to only have to change it in one place instead of several.
Can ONE create three additional tabs from existing tab that look exactly the same. Instead of copying them I would like to have the existing sheet be the master so all changes on that tab, will automatically update the other tabs.
Let me explain the purpose and end result:
I would like to use the existing tab to change the revenue. The second, third and fourth tabs will have columns and rows hidden so that I will make them presentable for committee meetings. Since this information will change frequently I want to only have to change it in one place instead of several.