Not sure if a formula approach can do this, or if I need to go with a VBA approach.
On the attached, I have 2 tabs. "Source" comes from another entity, as shown. "Formulas" is the work of my predecessor, and is the format my audience is used to and expects to see. As you can see, my predecessor's formulas are all linked into the proper cells in "Source". His method works as long as the other entity doesn't move anything, but I know from experience that stuff moves, so would rather go ahead and develop a more robust and sure lookup method. Knowing I really can't do much in terms of changing the "Formulas" format, how could I go from "Source" to "Formulas" effectively without the dedicated links?
Bookmarks