I have a macro set to run every time cell B6 changes (specifically, the macro uses "On.Entry" to run a Goal Seek every time B6 changes). I also have a data table with B6 as the "input" cell. But the data table outputs do not reflect the Goal Seek results of the macro that would run if cell B6 were changed to the respective input values. In other words, I want Excel to treat the data table inputs as if a user entered those inputs into cell B6, triggering the macro, so that the data table outputs reflect the goal seek having run.
To illustrate -- let's say that, when cell B6 is changed to the number 1, the goal seek function causes cell C1 to contain the letter "A", if B6=2, C1="B", and if B6=3, C1="C". And let's say the data table should show what C1 would equal if B6 were 1, 2 or 3. What happens is that the data table reflects only what the worksheet *currently* shows for cell C1. That is, if I enter 2 into cell B6, the data table shows that cell C1="B" for all three of the B6 input possibilities (1, 2 and 3), instead of showing "A", "B" and "C", respectively.
Thoughts? Thanks in advance.
To illustrate -- let's say that, when cell B6 is changed to the number 1, the goal seek function causes cell C1 to contain the letter "A", if B6=2, C1="B", and if B6=3, C1="C". And let's say the data table should show what C1 would equal if B6 were 1, 2 or 3. What happens is that the data table reflects only what the worksheet *currently* shows for cell C1. That is, if I enter 2 into cell B6, the data table shows that cell C1="B" for all three of the B6 input possibilities (1, 2 and 3), instead of showing "A", "B" and "C", respectively.
Thoughts? Thanks in advance.
