Samrat Mondal
New Member
I have a a large amount of data spanning around thousand rows. I am trying to use goal seek in each row to get a desired result. Is there a way to automate the goal seek operation?
Repeated Goal Seek
- Thread starter Samrat Mondal
- Start date
Somendra Misra
Excel Ninja
Hi Samrat,
Firstly, Welcome to Chandoo.org Forum!!
See the attached file. In the absence of a sample file. I had created this file which will operate goal seek on the cells as shown in file. Try to go through the macro & see if this meets your requirement.
Regards,
Firstly, Welcome to Chandoo.org Forum!!
See the attached file. In the absence of a sample file. I had created this file which will operate goal seek on the cells as shown in file. Try to go through the macro & see if this meets your requirement.
Regards,
NARAYANK991
Excel Ninja
Hi ,
Goal Seek might or might not be the required tool to get what you want , especially if you are using it on every row in a table of a 1000 rows ; can you explain what exactly you want done on each row of data ?
Narayan
Goal Seek might or might not be the required tool to get what you want , especially if you are using it on every row in a table of a 1000 rows ; can you explain what exactly you want done on each row of data ?
Narayan