Cut and Pasting Goal Seek

D

David

I've got a range of numbers where I'm looking to set a column of values to a
set value and have goal seek adjust the values in another column. Goal Seek
works but I have to apply the Goal Seek function separately to each row,
whereas I'd like to copy and paste it to save time but the Goal Seek function
does not allow this.

Is there a way of dealing with this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to create a goal seek button? 0
Goal Seek with variable Set Cell 1
goal seek function 3
Help understanding Goal Seek Calculation 3
Parameter Input for Goal Seek 2
Goal seek - Is there a bug? 2
Goal Seek stopped working 0
Goal seek on more than one cell 1

Top