I have a goal of saving up 25,000 and I can save. Simple Example: Scenario Say I want to save up for a house. Num_rows = ws_input.Cells(ws_input.Rows.Count, 1).End(xlUp).RowThe goal seek function is aiming to change one of the inputs in your model to meet an intended goal, or target, that you have selected.This can be either a value or formula in the Input sheet. Excel will try to make the cell in “Set Cell” to turn to the goal. This cell must be a link. Can be on a different page. Link this to the cell you are trying to set to a certain value. “Set Cell” is the cell that you want to get to a certain value. Even if the cell is a formula, it is ok! (Originally, goal Seek does not allow this cell to be a formula.)Set changing_cell_range = Range(ws_input.Cells(i, 3).Formula)'now that all the inputs are set, perform goal seek operation
![]() In summary, Excel will keep on changing the cell “By Changing Cell” to get another cell “Set Cell” to your predetermined value “To Value”. Link this to the cell that Excel can change. This cell must be a link. “By Changing Cell” is the cell that Excel can change to achieve the goal. This VBA Macro is a bit advanced in that it pulls the value of the cell, regardless of if it is a formula or not.) Digitalpersona firefox extensionMake sure the sheet is clean and there is nothing else on it. Your Input sheet should look something like the above.
0 Comments
Leave a Reply. |
AuthorJamie ArchivesCategories |