kshastry

Q: How to merge sheets with formula

I have a complex tracker with many sheets and cells having formula, with references to other sheets. Now, everyday I need to give this numbers file to multiple different team members, so that each one can update their respective sheets and send back to me. I am wondering what is the best strategy to merge updated versions of individual sheets into master numbers file.

 

If I simply copy the updated individual sheets and paste them in the master file one by one, they get new names (with a -1 added), and as soon as I delete the original outdated sheet, references from that sheet goes for a toss and get updated as #REF. Obviously, those messed up references do not come back even if I rename the newly copied file is renamed to original name.

 

Hope this is self explanatory. If not, I can explain the problem in a detailed manner. Please let me know a good solution for this. Thanks in advance.

 

PS. Maybe this is a cool enhancement opportunity too!

 

Regards,

Krishna.

Posted on Sep 9, 2016 4:51 PM