goal seek

Occasional Visitor

I'm trying to set up a spreadsheet to calculate the depth in an open channel.  I currently have it so that I can use the Goal Seek in the What if Analysis.  What I want to do is set it up so that I can change a parameter and have the program recalculate the depth without going through the steps of clicking on Data, then What if, then Goal Seek, then tag the cells and the difference.  All those steps are consistent.

Is there any way to do that? 

1 Reply


It would be possible to create a Worksheet_Change event procedure that runs automatically when you change a parameter, and performs the steps that you mention.

If you want help with that, it would be handy if you could attach a sample workbook without sensitive/proprietary information.