The Excel goal seek function only lets you goal seek one cell at a time. I have 3 entire columns of cells I'd like to "goal seek", is it possible to do this with a macro? I've attached an example spreadsheet which shows how the data is organized.
Thanks
Last edited by Test123Test; 06-13-2012 at 04:10 PM.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Thanks very much for this, just as described!
However I figured out I have a problem with the goal seeker on my main sheet. It seems to come up with "no solution" for the formulas I'm using. One solution would be to set the attempted values to between 0.01 and 1.00, so this is the min-max search range for the goalseeker. Is this possible in your macro? Perhaps with solve instead of goal seeker?
Nevermind, it's my data that's off. It can't find a solution because there is none, stupid me...anyways figured it out now, thanks much for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks