I am trying to construct a List from Data Validation to display values between zero and a maximum number that is referenced from another cell (say 20 for illustration purpose in this case).
Is there a way to accomplish this without creating a long list of numbers from 0 to the said predefined...
I have a file in which I want the user to be able to monitor the impact of changes to variables without having to keep going back to a summary worksheet to see the impact.
Basically I would like to set up a small "Result Table" that will hover at the side of each worksheet (regardless of...