External File Links I am working with a model that references an external file to pull in specific data points for multiple business units. The referenced file has all of the BUs in separate tabs. However, my model has all BUs in a single sheet. If I include in my file the exact BU tab names from the external file, can...I am working with a model that references an external file to pull in specific data points for multiple business units. The referenced file has all of the BUs in separate tabs. However, my model has all BUs in a single sheet. If I include in my file the exact BU tab names from the external file, can I create a formula in my model to automatically update the external reference such that it is only adjusting the tab from which it is pulling?Read More
I am working with a model that references an external file to pull in specific data points for multiple business units. The referenced file has all of the BUs in separate tabs. However, my model has all BUs in a single sheet. If I include in my file the exact BU tab names from the external file, can... I am working with a model that references an external file to pull in specific data points for multiple business units. The referenced file has all of the BUs in separate tabs. However, my model has all BUs in a single sheet. If I include in my file the exact BU tab names from the external file, can I create a formula in my model to automatically update the external reference such that it is only adjusting the tab from which it is pulling? Read More