View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David David is offline
external usenet poster
 
Posts: 1,560
Default Cut and Pasting Goal Seek

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?
--
David