goal seek multiple lines at one time

  • Thread starter Thread starter Jennifer E.
  • Start date Start date
J

Jennifer E.

I am using the goal seek function. I have data on each
each line of a spreadsheet and want to goal seek on for
each line. Is there a way to perform a goal seek for each
line without having to execute the command on each line.

Any help on this would be greatly appreciated.
 
Hi
AFAIK not possible without using VBA. You may record a macro doing this
manually and use this macro for this task
 

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

Assign a function to a Command Button 3
Goal Seek returning different results 3
Goal Seek 3
Inputs for Goal Seek Command 4
HOW DO I SET PERMANENT GOAL SEEK IN EXCEL 1
Goal-Seek Question 7
Goal Seek with Complex Numbers 2
Goal Seek Bias 1

Back
Top