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.
I had to delete some rows to reduce the file size for uploading.
GCS-CS Distance Variation.xlsm
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?
Sub WW89() Dim cell As Range For Each cell In Range("G3", Cells(Rows.Count, "G").End(xlUp)) cell.GoalSeek Goal:=0, ChangingCell:=Cells(cell.Row, "F") Next cell End Sub
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