Results 1 to 4 of 4

Hiding columns based on drop down list selection

Threaded View

  1. #1
    Registered User
    Join Date
    04-11-2014
    Location
    dubai
    MS-Off Ver
    Excel 2013
    Posts
    4

    Smile Hiding columns based on drop down list selection

    I have looked at many threads on this and cannot find a solution that will work for me.
    I am trying to set up a sheduling system for my work. I have hundreds of columns that will have dates as the heading. There will be 6 columns per date to represent different shift timings.
    I have a drop down box that you can pick the appropriate shift (2, 4, 6, 8, 12, 24).
    When the shift is chosen, all columns that do not match the selection are hidden.

    I have attached an example if anyone would be able to assist please.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help hiding rows based on drop down selection
    By J-Fly in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 11-23-2012, 02:07 PM
  2. Hiding rows based on drop down selection of cell
    By J-Fly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2012, 01:37 PM
  3. [SOLVED] Hiding Columns based on the value of a drop down list
    By ExcelNewbie2534 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-18-2012, 07:03 PM
  4. Hiding Columns based on Drop Down list selection
    By forge13 in forum Excel General
    Replies: 5
    Last Post: 11-25-2011, 07:39 AM
  5. Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 10-30-2011, 09:24 AM
  6. Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2011, 06:49 AM
  7. Hiding Rows based on Drop Down menu selection
    By smurph_27 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2008, 08:36 PM

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