Hi Everyone, I posted this on another board but have not heard back anything yet.
I am new to the board and with minimal VBA experience, and I am hoping that someone can help me with the following:
I have a sheet with hundreds of rows and columns, which I want the end-user to easily be able to use checkboxes to hide/unhide any columns or rows they wish based on three sets of values in the column headers and row headers.
Please see the simple example attached.. I have tried several different pieces of code for the checkboxes but nothing has worked for both rows and columns yet.
For instance, if a user unchecked all boxes except for "Apples" and "3", it would only display columns with "3" in row 5 and only display rows with "Apples" in column A.
Any help would be greatly appreciated. Thanks to all!
Bookmarks