Creating a Calculation Sheet by linking in data from cells on one sheet to another sheet
I have a project Plan with almost 900 lines and have cloned that sheet so to keep the existing columns, but allow me to add additional columns I can use to calculate data for use in a separate dashboard. I do this all the time with no problem. This time however, someone on my team created the new 900 line plan and I copied it to my workspace, then I copied it so I could use the copied version as my "calculation sheet for that plan". But, for some reason, when I try and link the cells from the original 900 line project plan to the copied version (Calculation Sheet) it does not allow me to link the cells, any ideas as to why this is being prevented where I have not had a problem in the past?
Could it have to do with Parent to Child lines from the original 900 line plan?
Help Article Resources
Check out the Formula Handbook template!