I always seem to be asking simple questions, I hope that this is another easy one for the brains here.
I have a formula that converts location numbers to their respective addresses. I use this formula repeatedly in many of the reports that I produce. As the company that I work for expands more locations are added. Therefore I have to go into each report and update the formula with the new address information.
Is there a way (there must be) of setting up one formula and having the reports link to that formula to get the correct information? That way I would only have to change the information in one place instead of every single report.
Thanks,
I have a formula that converts location numbers to their respective addresses. I use this formula repeatedly in many of the reports that I produce. As the company that I work for expands more locations are added. Therefore I have to go into each report and update the formula with the new address information.
Is there a way (there must be) of setting up one formula and having the reports link to that formula to get the correct information? That way I would only have to change the information in one place instead of every single report.
Thanks,