View Single Post
  #1   Report Post  
Juana Cafe
 
Posts: n/a
Default 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.