Share via

How to: Dynamic Checkboxes

Anonymous
2024-08-01T17:39:36+00:00

Hello! I have a dynamic list in which the Product column (B7:B12) updates if there are blanks in the review description column (C7:C12). As displayed in the screenshot below, I have extra checkboxes as when I change my dropdown in C3 from "Poor" to "Good", the list is minimized by 2, but the checkboxes remain. Is there a way to make these dynamic to correlate with how many Products and Review Descriptions I have on the left?

Furthermore, I would like this to correlate with my "Complete Tasks" and "Percent Complete" in D14:D15

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-08-03T12:55:09+00:00

    Hi ExcelNewbie101,
    Thanks for your post in Microsoft Community.

    Using a single formula might not achieve more complex dynamic linking functionality. 

    Therefore, if it's convenient for you, please share your workbook file with us via private message so we can write formulas and troubleshoot errors more effectively.

    I look forward to your reply!

    Best Regards, 
    Thomas C - MSFT | Microsoft Community Support Specialist

    0 comments
  2. Anonymous
    2024-10-29T12:13:05+00:00

    Hi ExcelNewbie

    Did you ever get a proper answer on this? I would now like to get that answer as well.

    Thanks.

    Renier

    0 comments