1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Dropdown List Capabilities in a single sheet

Hi, I am trying to construct a basic tracker to document the status of different items on my sheet. I am using checkboxes to document any line items current status within a given month. Now since I am tracking per month, I would like to have a dropdown list that when changed, it will change/clear all the checkboxes for starting a new month. I would like to be able to keep the data of what checkboxes are marked for past months so that I can go back to a previous month and see historical data. Is this possible?

submitted by /u/sdruizz
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article