Results 1 to 2 of 2

Thread: Multi Selection appear in individual Cell when selected

  1. #1
    Neophyte cgibson92's Avatar
    Join Date
    Jun 2015
    Location
    Tulsa, OK
    Posts
    1
    Articles
    0

    Multi Selection appear in individual Cell when selected



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Is there any way to make the items in the multi select boxes to also appear in the cells to the right of that box (individually)? Only 2 to 3 will appear at any given time in cell B36 based on what their contract has and when they are selected the worksheet will open that corresponds with the selection. When i select an "incentive type" it opens up the correct worksheet, but when selecting an "incentive area" cell B51 the worksheet previously selected disappears? When we select an "incentive area" that should not have any thing to do with the worksheet should be hidden or not. I just want to be able to put just one selection into the corresponding worksheet when it is selected. I have tried vlookup and an if statement but neither seem to get me the results that i am looking for. I have attached a sample file any help or advice would be much appreciated.

    Thanks
    Cindy

    Test.xlsm

  2. #2
    Acolyte jaslake's Avatar
    Join Date
    Aug 2011
    Location
    mineral city oh usa
    Posts
    81
    Articles
    0
    Excel Version
    2007;2010;MAc2011
    John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •