select columns based on value in a row

Question

I am trying to select columns based on Value in “Month” column. See Example below. If “Month” has OCT it should pick all columns Jan thru Sep and column “New OCT” (Highlighted in Blue). The Month Column is based on a formula and it changes. So if it’s NOV, It should pick all months Jan thru OCT and “New Nov”. See screen shot below

CoG · Accepted Answer

Here is a non-macro solution that can achieve this outcome as well:

By using the Field Info Tool, we can manipulate the column names and identify which ones to keep/remove via Dynamic Select.

Hope this helps and Happy Solving!