Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
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
Show All 1 Replies
Login to Reply
0
by Jennifer K.
added 8 years ago
