Help with code for Goal Seek
Hi, I have the following code, but it doesn't work!
--
Please Login or Register to view this content.
Basically I have a drop down bar in cell R15C9, everytime that cell changes, I want Goal Seek to automatically make 2 calculations, one is to change M38 so that M40=0, and the other is to change M49 so that M51=0.
Somehow the code above isn't working for me. Any idea why?
Thanks in advance for any help you can give!
Last edited by Cutter; 08-17-2012 at 09:53 PM. Reason: Added code tags
I'm uploading a test file with the code to clarify my question....
It seems to work for the most part but NOT when Cell C2 is set to 2.
Tearing my hair out....
[cross posted here: http://www.mrexcel.com/forum/excel-q...l#post3243297]
Reckon that's just a limitation of Goalseek. You could switch to Solver, or just use a formula in H6:
=((J11+1)*F9 - SUMPRODUCT({100;101;99}%*F6:F8)) / SUM(F6:F8)
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks