MS Excel issue

byronlgordon

Honorable
Jul 26, 2012
1
0
10,510
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.
 

chugot9218

Honorable
If you select the data you want to move to the other sheets and copy it, then right click on the sheet you want to add it to, it should give you the option to "Paste a Link". This will essentially paste a pointer to the specified data on the previous sheet, allowing you to update the single sheet and present only the data you want from the original on the others. Let me know if that was not clear!