+ Reply to Thread
Results 1 to 3 of 3

Display a Form based on multiple cell values

  1. #1
    Registered User
    Join Date
    10-21-2016
    Location
    NB, Canada
    MS-Off Ver
    2013
    Posts
    2

    Display a Form based on multiple cell values

    Hello
    I am working with an excel sheet that has multiple options and from those would have a few forms. I have conditions for the first part of what i need

    ex> Location: this is a drop down with a list
    Location Workgroup: based on the location this will provide a list of workgroups

    Then under that I provides more information but with the request type: New, Change, Delete - I would like a form displayed so the user knows what needs to be completed. I have attached a sample of my sheet but I'm running into some issues as there are multiple lines for some of the items ie: Under application there are 2 items but only one showing

    HELP!!!!

    THank you
    Last edited by jcbarte; 08-30-2019 at 12:03 PM. Reason: Updated attachment

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Display a Form based on multiple cell values

    Welcome to the forum

    Please 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.

  3. #3
    Registered User
    Join Date
    10-21-2016
    Location
    NB, Canada
    MS-Off Ver
    2013
    Posts
    2

    Re: Display a Form based on multiple cell values

    Hi there
    so sorry, I thought I had included the attachment - I think I have successfully completed that now. I have also included a spreadsheet with the end result I am looking for.

    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 08-22-2018, 06:42 PM
  2. Replies: 1
    Last Post: 02-03-2015, 01:23 AM
  3. Display values based on multiple DV values
    By lostinmsexcel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2014, 11:13 PM
  4. VBA Form -- Display Values based on dependent lists
    By zaveed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2013, 11:46 AM
  5. Populate a form from different workbook based on multiple cell values.
    By jrtraylor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2012, 01:50 AM
  6. Multiple values display in same cell?
    By chubstyk in forum Excel General
    Replies: 4
    Last Post: 10-05-2011, 06:29 AM
  7. Display changes in cell based on values
    By oliver79 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-24-2009, 06:14 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