Am working on a standard leveraged buyout model. Quick question. I am creating a formula on Sheet A ... what is best ... referencing the input cell directly on another sheet (sheet B) or referencing the same value from elsewhere on Sheet A (which the input has already fed into)? What is considered best practice ..? One method is more consistent and perhaps allows easier auditing ... but the other allows the user to see what is happening on the same sheet without having to constantly go to other pages?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Jerry Sullivan
MrExcel MVP
- Joined
- Mar 18, 2010
- Messages
- 8,787
Welcome to MrExcel,
I believe you've identified the pros and cons of those two options pretty well:
Referencing the input cell on Sheet B is more consistent and more robust in the event of changes than the indirect reference.
The indirect reference to the same value on Sheet A may be easier for the worksheet user to follow.
I'm not aware that there is a consensus best practice, but I'd recommend a third option: Defined a Name for the input cell on Sheet A, then use that Name throughout the workbook to refer to the value in the input cell.
I believe you've identified the pros and cons of those two options pretty well:
Referencing the input cell on Sheet B is more consistent and more robust in the event of changes than the indirect reference.
The indirect reference to the same value on Sheet A may be easier for the worksheet user to follow.
I'm not aware that there is a consensus best practice, but I'd recommend a third option: Defined a Name for the input cell on Sheet A, then use that Name throughout the workbook to refer to the value in the input cell.
Upvote
0
Similar threads
- Question
- Solved
