LinkBack URL
About LinkBacks
Hi!
I am wanting to perform goal seek simultaneously on an entire column of data. I would like to have the cells from G3:G10000 set equal to 0 by changing cells F3:F10000.
Thanks for any help!
Hi!
I am wanting to perform goal seek simultaneously on an entire column of data. I would like to have the cells from G3:G10000 set equal to 0 by changing cells F3:F10000.
Thanks for any help!
Goal seek can only change a single cell. Solver can change more cells toward meeting an objective function, but not that many.
Entia non sunt multiplicanda sine necessitate
I was hoping a macro could be used to change each set of cells so that I don't have to perform goal seek 10000 times.
That's easy, as long as only one cell needs to change at a time in each row.
Yes. I want G3 set equal to zero by changing F3, G4=0 by changing F4, etc. I just have no experience with macros. I have tried modifying some that I have seen posted and recording my own and then modifying, but keep getting compiling errors.
Can you attach a file to get your request clearly?
Please Login or Register to view this content.
I had to delete some rows to reduce the file size for uploading.
GCS-CS Distance Variation.xlsm
Thank you! This worked perfectly!
You're welcome.
I think it takes a long time to do the task
Is there a way to reduce the time spent to run the code?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks