Mass (specific) Hide/Un-hide Columns

Hello,

I hope you all can help. I have a spreadsheet with dozens of sheets that contain pivot tables. It's based on a year's time with two columns for each month. One for Actual and one for Goal. Because of the way the pivot tables are set up, I need to have columns for each, but I only want one showing. The Goal column should be unhidden with the Actual hidden until the current month arrives. Then I would hide the Goal and unhide the actual.

Is there a way I can hide, for example, all of the July Goal Columns on each sheet and unhide all of the July Actual columns at once?

Thank you for any advice/guidance you can give.

Moderator's note: Cross-posted at https://www.mrexcel.com/forum/excel-...-workbook.html

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Read this to understand why we (and other sites like us) consider this to be important.

I have added the link for you because new members may not post links but please bear this in mind in the future.