Macro to Select Month and all other columns containing the months and years to be hidden

**Howardc1001** · 11-05-2020, 10:11 PM

I have Month and year in B4:M4

I would like a macro that when I select a month from a list then all the other columns containing the months and year to be hidden

I have attached sample data

Your assistance is most appreciated

**nankw83** · 11-06-2020, 03:48 AM

Hi Howardc,

Right click on sheet "BR1" tab --> View Code then paste the below ...

Please Login or Register  to view this content.

**Howardc1001** · 11-06-2020, 04:02 AM

Thanks for the help.

When I select say December , then I want the column containing December to be unhidden and all the other columns containing the months and year to be hidden

Kindly amend your code

**nankw83** · 11-06-2020, 04:24 AM

Try below code ...

Please Login or Register  to view this content.

**Howardc1001** · 11-06-2020, 05:09 AM

Thanks for much for your help

**nankw83** · 11-06-2020, 07:31 AM

Glad to help & thanks for the added Reps.

Macro to Select Month and all other columns containing the months and years to be hidden

LinkBack

Thread Tools

Rate This Thread

Display

Macro to Select Month and all other columns containing the months and years to be hidden

Re: Macro to Select Month and all other columns containing the months and years to be hidd

Re: Macro to Select Month and all other columns containing the months and years to be hidd

Re: Macro to Select Month and all other columns containing the months and years to be hidd

Re: Macro to Select Month and all other columns containing the months and years to be hidd

Re: Macro to Select Month and all other columns containing the months and years to be hidd

Thread Information

Users Browsing this Thread

Similar Threads

if month & year = current month, return 1, otherwise 1 + percentage from one month back

[SOLVED] Convert calendar year month to fiscal year month

Macro to calculate Month to year sales based on month selection

Running Totals from 24 hours to month, month to year without year decreasing

Macro that select and plot the graph from some columns every month

How to add Month-on-Month and Year-on-Year %Variance into a pivot table

If Column A Month and Year = ColumnB Todays Month and Year then send email

Bookmarks

Bookmarks

Posting Permissions