goal seek multiple lines at one time

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.
 
F

Frank Kabel

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
HOW DO I SET PERMANENT GOAL SEEK IN EXCEL 1
Goal Seek with Complex Numbers 2
Goal-Seek Question 7
goal seek minimize function 4
Goal seek multiple cells 1

Top