Results 1 to 6 of 6

How to Hide Columns based on Two Drop Down Menus

Threaded View

MILCAL3 How to Hide Columns based on... 12-20-2011, 07:30 AM
dilipandey Re: How to Hide Columns based... 12-20-2011, 07:42 AM
arlu1201 Re: How to Hide Columns based... 12-20-2011, 07:44 AM
MILCAL3 Re: How to Hide Columns based... 12-20-2011, 07:56 AM
watersev Re: How to Hide Columns based... 12-20-2011, 09:57 AM
MILCAL3 Re: How to Hide Columns based... 12-20-2011, 12:16 PM
  1. #1
    Registered User
    Join Date
    12-20-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    3

    How to Hide Columns based on Two Drop Down Menus

    Hi,

    I have a spreadsheet which I would like to hide columns based on two sets of criteria contained in drop down menus.

    I have two drop down menus, one has month (Jan-Dec) in cell A2 and one has year (12, 13, 14) in cell B2.

    The months run in columns D4 to BV4 with a space column in between each month e.g. column D = Jan-12, column E = splitter, column F = Feb-12.

    I would like users to be able to filter to show only a specific month and year based on choices made in the two drop down menus.

    I have attempted to find an answer in forums but as I am new to VBA I am struggling and I am not sure if it works using drop down menus? Any help would be greatly appreciated!

    Thank you!
    Last edited by MILCAL3; 12-20-2011 at 12:20 PM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1