Results 1 to 6 of 6

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

Threaded View

  1. 11-05-2020, 10:11 PM #1
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2024
    Posts
    2,873

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

    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
    Attached Files Attached Files
    Last edited by Howardc1001; 11-06-2020 at 01:17 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. if month & year = current month, return 1, otherwise 1 + percentage from one month back
    By losincog in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-04-2020, 04:02 PM
  2. [SOLVED] Convert calendar year month to fiscal year month
    By sheetnoob in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-13-2018, 03:30 AM
  3. Macro to calculate Month to year sales based on month selection
    By chandu356 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-14-2017, 09:58 AM
  4. Running Totals from 24 hours to month, month to year without year decreasing
    By Safetyintern in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-20-2015, 01:13 PM
  5. Macro that select and plot the graph from some columns every month
    By vijayj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-05-2013, 05:36 AM
  6. How to add Month-on-Month and Year-on-Year %Variance into a pivot table
    By emeritus1812 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-09-2013, 02:37 AM
  7. If Column A Month and Year = ColumnB Todays Month and Year then send email
    By HACCStaff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:47 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1