I am trying to build a valuation sheet for our employees to value and rank the company overall or by business unit. I want the sheet to be variable, so that way they don't have to enter all values or can enter some and the sheet will pull default values for the output. I am trying to do this with formulas instead of vba to keep it end user simple. I can put most of it together, but when it comes to linking the top and bottom sections or having them reference each other, i start down the circular reference rabbit hole
Formula sheet with multiple inputs and outputs
-
-
-
Hello,
Attached is a guess of what you might be looking for ...
Blue Cells are your input cells ...
Hope this will help
-
Thanks for taking a look. I guess i wasn't too clear that i was trying to have the input valuation and the per business unit valuation both be able to interact with each other as well. That is where i started running into the circular reference and couldn't see a way out of it, outside of using VBA to extract the known references and calculate accordingly.
-
Thanks for taking a look. I guess i wasn't too clear that i was trying to have the input valuation and the per business unit valuation both be able to interact with each other as well. That is where i started running into the circular reference and couldn't see a way out of it, outside of using VBA to extract the known references and calculate accordingly.
Sorry ... but have to confirm you are not too clear about the interactions you want to build ...
Could you attach the Test file with some written comments next the cells ... ?
-
Attached is a revision with notes next to the boxes and my issueValuation Exercise.xlsx
-
-
Thanks for your notes.
Could you explain even further the detailed relationship between the cells ...?
It seems to me you are after creating mutually exclusive cells...
Is that right ...?
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!