View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default

If I can offer an opinion: to relieve all the annoyance, would it be an
idea to have your "Control" tab contain the master information, and
have the "Model" tab refer to the Control tab for key data points.
That way the key data is found in one and only one place. If you have
to change the key data points frequently, you can have two instances of
the spreadsheet showing the Control tab and the Model tab onscreen
simultaneously.

I've found this works for me. Pontification ends here!