On the attached spreadsheet I created a simple Goal Seek macro to return a Profit Value (cell L5) by changing N5 to equal E5.
Please Login or Register to view this content.
What would code be to repeat this same caclulation for the various other rows in Column L?
Thank you.
PS very new to VBA so simplified explanation appreciated if possible.
Bookmarks