How to Create a Progress Tracker Controlled with Checkboxes in Excel

Поділитися
Вставка
  • Опубліковано 21 жов 2024

КОМЕНТАРІ • 16

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

    thank you, exactly what I needed

  • @transcendingthedyad5663
    @transcendingthedyad5663 Рік тому +3

    Man with that amazing voice you should be recording audiobooks.

  • @sdewviljoen
    @sdewviljoen 8 місяців тому

    Thanks! We are tracking UAT case completion - each step is a row - so this works perfectly!

  • @IvanCortinas_ES
    @IvanCortinas_ES Рік тому +1

    Excellent analysis Chester. Absolutely essential for controlling processes. Thank you Chester!!!

  • @shakilanjum911
    @shakilanjum911 Рік тому +1

    Exactly what i was looking for. I saw an implementation of this using sparkline, however this one seems easier. Thanks

  • @dr.mdabdulkader8975
    @dr.mdabdulkader8975 6 місяців тому

    Excellent tutorial

  • @Puneeth-dc3lv
    @Puneeth-dc3lv 7 місяців тому +2

    Hi there, so if there are multiple check boxes say 30 rows and 10 columns, do we have to go into each one for the formating to attach the cell link or is there a short cut for it? Any advise would be appreciated. Thanks!

    • @AllyG1967
      @AllyG1967 5 місяців тому

      Agree, there must be a way to make that step less tedious for larger data sheets - help from somewhere please :)

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

    Thank you very much for this Video.
    Do you know, do i have to link every checkbox seperatly, or is there a way to do a lot of them at once?

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

    OMG THANK YOU YOU ARE AMAZING! INSTANT SUBSCRIBE ♥

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

    Excellent

  • @israelderas1673
    @israelderas1673 10 місяців тому

    Hi Chester, thank you for all your videos, they help a lot. I wonder is you be kind to share a formula that I cannot make to work yet, I need to add total value of one code between dates, If I do it separayly just looking between dates it give the how many Code do I have, but no count the quantity of the code, the columns are DATE, CODE and QUANTITY. Can you help me with that, please?? thanks

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

    Amazing thank you

  • @KristelYee
    @KristelYee 4 місяці тому

    Hello! I am wondering if we can use the progress bar be controlled by a dropdown list. Thank you!

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

    Is there a way to get around the "you've entered too many arguments" error
    My check boxes aren't all in a single row/ column

  • @BryanM-xj9rp
    @BryanM-xj9rp 8 місяців тому

    I've downloaded the sample. Try as I might, I simply cannot add more rows instantly to add to the spreadsheet. When I do, the new row and its check boxes interact with the above row, I figured there was a way to mass produce lines. Bummer.