Goal Seek Macro for multiple lines

[ksamarin88]

I have a formula that I have been using Goal Seek to solve and it works perfectly. My issue is that I have 1000+ lines of data that I need to use that for and do not have the time to waste to do that for all of those cells. Does anyone have a macro that I can use to replicate that over numerous cells?

[JOHN H. DAVIS]

Here is a macro that I use for multiple lines, I don't know if you can modify it for your purposes or at least use some of the ideas.

Please Login or Register  to view this content.

[ksamarin88]

Thank you, John. That was helpful.

[JOHN H. DAVIS]

You're welcome. Glad I could help out.