+ Reply to Thread
Results 1 to 2 of 2

Unhiding hidden columns from a drop-down menu

  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    Douglas, Isle of Man
    MS-Off Ver
    Excel 2007
    Posts
    6

    Unhiding hidden columns from a drop-down menu

    I have a list of mandatory training policies that has to be completed by a whole department, and it is the job of multiple line managers to keep up to date with all the mandatory training. The attached spreadsheet is to be send out to every line manager so that they can input the names of those they manage and fill in compliance. There are 39 mandatory training courses, but only the first five are required by every employee, the rest only apply to select groups, and even select individuals. I have named each of the policies so that they can be easily jumped to, and these can be selected from the drop-down menu above the table. However, what I was hoping to achieve was, upon opening, to have every column hidden except for the first five, as these are required by everybody, then once a policy is selected, the selected column would unhide so that data can be filled in. This would mean that only the policies applicable to that line manager would show, thus making it easier to enter data. I'm not sure if this is possible as I am a bit of a novice to Excel, and I'm not expecting it to work, but if anyone has any idea if this is feasible, and if not could offer an alternative solution, I would greatly appreciate it.
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Unhiding hidden columns from a drop-down menu

    What about having each training course own it's own page? The Name Box will still allow you to jump the the corresponding page.

    Also, you should make this a Shared worksheet, so when they return it to you, it will be easy to pull the data into a master sheet.
    David
    (*) Reputation points appreciated.

+ Reply to Thread

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