Roze
New member
- Joined
- Aug 24, 2020
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016
Hi there,
I am looking for some help in problem solving and figuring out why the code I am using is failing to do what it is meant to do.
I have a master sponsorship tracking Excel document that will be used to track deliverables. We need to be able to filter (hide/view) columns so we can only see certain categories of columns at once, which we can select from a drop down menu.
The excel sheet contains roughly 180 columns with column headers. Above these headers is an additional row of headers that are to be used by the Pivot Table and the VBA code for filtering.
I copied an online guide on how to do this, found here: https://www.excelcampus.com/vba/hide-unhide-columns-slicer-filter/
The excel doc is attached here. The issue is that is it is not working and I do not know why. I would greatly appreciate your help.
Thank you!
I am looking for some help in problem solving and figuring out why the code I am using is failing to do what it is meant to do.
I have a master sponsorship tracking Excel document that will be used to track deliverables. We need to be able to filter (hide/view) columns so we can only see certain categories of columns at once, which we can select from a drop down menu.
The excel sheet contains roughly 180 columns with column headers. Above these headers is an additional row of headers that are to be used by the Pivot Table and the VBA code for filtering.
I copied an online guide on how to do this, found here: https://www.excelcampus.com/vba/hide-unhide-columns-slicer-filter/
The excel doc is attached here. The issue is that is it is not working and I do not know why. I would greatly appreciate your help.
Thank you!