200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I have mulitiple columns that all have different values in the corresponding rows. I would like to be able to "select" various combinations of these columns and subsequently have a total of the values of rows.
Is there a way to "activate" or "deactivate" a column to make this work? I am thinking of maybe like a "checkbox" at the top of each column that I could easily select and deselect.
You could select all the data, go to an empty worksheet, and right-click a cell and then Paste Special > Transpose; once you do this you can use the Filter feature to literally select and deselect rows using a checkbox interface.
Make sure each column has a header before applying the filter.
