Dear all,
I have developed a business case on with assumptions, calculations and results on 3 different sheets.
On the 3rd sheet I now want to add a data table to check the sensitivity of 2 input variables.
In order to do so I referenced these input cells to the results-sheet and created a data-table.
Now, after adding the data-table, a lot of cells on the result-sheet keep changing randomly... Anyone has a clue what could be happening?
Many thanks!
Jeroen
Does the range on those cells that keep changing, include the new data?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I'm not sure if I understand what you mean with 'new data'.
Lets say on the result-sheet A1:C5 are populated with general results
and the data table (A8:C12) analyzes the effect on the result of A2.
After adding the data-table, and adding random numbers/text in cell F9, both data in A1:C5 as in the data table mysteriously change....
upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
unfortunately it is too big to sent a clean version....
Without seeing what you have, it's hard to ID what might be causing the problem.
We dont need to see the whole file, just enough so we can see what you are working with (dummy data if needed)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks