Hi,
New forum user here!
1 - I want any and all changes to a "master sheet" to be mirrored in the "non-master" linked sheets. This would include changes to the text, numbers, formulas, number formats, style formats, conditional formats, etc.
2 - My master sheet has blank cells. It also has cells that contain zero-values ("0", "0.0", "0.00", etc). I want these cells reflected identically in the non-master linked sheets.
3 - My master sheet has a drop-down filter box for every cell across Row 2. I want this to show in each non-master sheet too.
4 - I would like any and all changes to the non-master sheets to be independent of the other sheets. This would include changing the column order, filters, header, footer, etc.
For example:
a - Sheet1 is the master.
b - Sheet2 and Sheet3 are linked to Sheet1.
c - Any change to Sheet1 is reflected in the other sheets.
d - Any changes to Sheet2 only show in Sheet2.
e - Any changes to Sheet3 only show in Sheet3.
This would help a lot! Thank you!!
Bookmarks