Goal Seek Analysis for Multiple Cells (Excel VBA)

Поділитися
Вставка
  • Опубліковано 23 січ 2025

КОМЕНТАРІ • 32

  • @hdtass
    @hdtass 3 роки тому +5

    Legend. So simple - have been mulling over how to do this for weeks and you show me in 3 lines of code in 2 minutes even though I have never coded ever. Thanks!

  • @maqabayker
    @maqabayker Рік тому

    Truly an engineering-hack! You really helped, man. You are Legend!
    I tried to set it somehow differently to have inputs but then said myself to just use the basic functionality and get the results.

  • @limarandos
    @limarandos 2 роки тому

    Hey man, thank you so much for taking the time to do this video.

  • @ricardocruz8252
    @ricardocruz8252 Рік тому

    Thank you so much!! So simple and easy to make modifications. Appreciate you!

  • @potentious1
    @potentious1 2 роки тому

    Just came across your page. Super simple, concise, and helpful. This is great, thank you for sharing your knowledge.

  • @cynthia7265
    @cynthia7265 Рік тому

    Thank you so much for sharing, wish you have a great day.

  • @iniah
    @iniah Місяць тому

    HI Can you explain how to get the macro to work across multiple rows?

  • @ericwhittaker3570
    @ericwhittaker3570 4 роки тому +1

    This video made me look smarter than I really am. Thanks!

  • @SALIS_LIGHT
    @SALIS_LIGHT 3 роки тому

    Great work. Simply and easily described each important step in the shortest time possible. Thank you very much indeed.

  • @Pauwel2324
    @Pauwel2324 9 місяців тому

    What if I want the goal seek value to be different for all lines?

  • @kunalvegada1405
    @kunalvegada1405 Рік тому

    sir how to use for multiple cells.. my example if if i two columns one is department other is expenditure i want to change total of expenditure by varying all departments expenditure

  • @kamwalebanda2979
    @kamwalebanda2979 Рік тому

    Hello am runing the code but still geting an error, can i whats app you

  • @dzmitryzhylinski8143
    @dzmitryzhylinski8143 2 роки тому

    Hey, is there the same solution for Google sheets?

  • @vaibhavgupte7921
    @vaibhavgupte7921 4 роки тому +3

    This works when your table is vertical. how to make it work when you table is horizontal. i.e. when i want the next j to next column and not a row

  • @goureshpowar6902
    @goureshpowar6902 3 місяці тому

    Legend!!

  • @joshf1234
    @joshf1234 3 роки тому

    I literally love you

  • @steverich977
    @steverich977 9 місяців тому

    Thanks for the video!

  • @Dilume
    @Dilume 3 роки тому

    Thanks for the video and the file, that was really helpful

  • @gavilanmusic6457
    @gavilanmusic6457 3 роки тому

    New to VBA- what is the importance of "j" in this?

  • @Greymatter57
    @Greymatter57 2 роки тому

    Thank you, it was very simple and nicely explained. It helped me in my project which had some deadlines. Can we do the same for rows? You example had columns from 5 to 13 assigned to variable j.

  • @thanhlongtran4104
    @thanhlongtran4104 3 роки тому

    Thank you very much. Its very helpful.

  • @faysalahmed1253
    @faysalahmed1253 2 роки тому

    where is the seek button code

  • @LumpineeSTD
    @LumpineeSTD 4 роки тому

    U are the King

  • @matthewbrierley88
    @matthewbrierley88 4 роки тому

    Amazing. Legend. Thank you!

  • @TheZaffi69
    @TheZaffi69 4 роки тому

    Excellent video! really good!

  • @dwarkesh27jayram32
    @dwarkesh27jayram32 2 роки тому

    Thank you really helpful.

  • @monsieurgurbuz
    @monsieurgurbuz 14 днів тому

    thank you soo much

  • @alexandrusichin
    @alexandrusichin Рік тому

    Masterpiece

  • @gametym8102
    @gametym8102 3 роки тому

    Thank you very much sir

  • @03santuy73
    @03santuy73 3 роки тому

    Thank you sir

  • @raphaelaguiar502
    @raphaelaguiar502 4 роки тому

    Thanks