Updating Excel Data on Multiple Sheets
Have a master sheet with several subordinate sheets with same data but in
different format. Subordinate sheets update when master changes except if
cells are moved on master. Then formula relationship is lost and all that's
left to do is copy and paste. Is there a way to keep the reference to the
master sheet intact even if the cells are moved.
|