+ Reply to Thread
Results 1 to 4 of 4

Set up worksheet to show/hide sections based on items selected in a dropdown menu

  1. #1
    Registered User
    Join Date
    04-29-2016
    Location
    ireland
    MS-Off Ver
    2016
    Posts
    7

    Set up worksheet to show/hide sections based on items selected in a dropdown menu

    Hi All,

    I have a pricing house renovation document with about 10 pricing sections on the one worksheet.
    All sections are rarely used for each job but no job is ever really the same.

    What I'd like to be able to do is have a drop down menu at the top of the sheet where I can select what items will be used for this job.
    This will then populate the sections I require.

    Another item I'd like to be able to incorporate is where there are multiple types of house on one estate, ie Type A, Type B, Type C, Type D
    Would it be possible to add columns based on how many different house types I require.

    All help is greatly appreciated.

    If required I can send a sample of the existing document.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    6,758

    Re: Set up worksheet to show/hide sections based on items selected in a dropdown menu

    Do attach a sample. It will help us understand the requirement and come up with a solution.

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    04-29-2016
    Location
    ireland
    MS-Off Ver
    2016
    Posts
    7

    Re: Set up worksheet to show/hide sections based on items selected in a dropdown menu

    Thanks for the response.

    I'm not sure if the doc is attached or not, I've tried a couple of times but can't see whether or not it is actually attached.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-29-2016
    Location
    ireland
    MS-Off Ver
    2016
    Posts
    7

    Re: Set up worksheet to show/hide sections based on items selected in a dropdown menu

    The ORIGINAL tab is the worksheet I'm currently using.
    All sections are required.
    It's very cluttered and I'm hoping that I can get a bit of advice on how to redesign it to make it a bit more user friendly.

    The STRIPPED DOWN tab shows the list of all possible upgrade items I2:L19
    I think that it might be better to have a check box next to the list of possible upgrade items (I3:I18) rather than a drop down menu as I will need to display the info in I2:L19 anyway.
    If an item isn't selected then it should disappear to clean up the sheet a bit, see the DESIRED OUTCOME tab.

    Something else I'd like to happen is that when you select a work measure (ie on the STRIPPED DOWN tab, cell A37) the corresponding UNIT BASE RATE (D37) changes accordingly.
    How do I go about setting up pricing for each element, could this be done on the MEASURE DATA tab where there are dynamic lists for each of the upgrade measures?

+ 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