Results 1 to 5 of 5

Thread: Dropdown list causes to show some comment from different sheet

  1. #1

    Dropdown list causes to show some comment from different sheet



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

    I have about 11 sheet in one excel each have some text.
    Now i want to show specific text Contained in 11 specific sheet) text under that same named sheet as note of the cell when i chose the name of the sheet from dropdown manu


    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    What information do you want to get from the sheets?


  3. #3
    Conjurer snb's Avatar
    Join Date
    May 2013
    Posts
    374
    Articles
    0
    Excel Version
    2020
    What is the result you are after ?

  4. #4
    Thank you for your reply.
    Actually I want to show the specific text in from one sheet. Now in the first sheet I have a dropdown list with the name of each sheet. Now when I select the name of sheet from that drop down manu I want to show the specific text beside cell from the drop down many.Suppose one sheet have name "atmospheric tank"it has some text. So when I chose atmospheric tank from sropdown manu I want to see the text expaling theatmospheric tank" beside it cell. Regards

  5. #5
    please check the attached fill

    Quote Originally Posted by Ch1253 View Post
    Thank you for your reply.
    Actually I want to show the specific text in from one sheet. Now in the first sheet I have a dropdown list with the name of each sheet. Now when I select the name of sheet from that drop down manu I want to show the specific text beside cell from the drop down many.Suppose one sheet have name "atmospheric tank"it has some text. So when I chose atmospheric tank from sropdown manu I want to see the text expaling theatmospheric tank" beside it cell. Regards
    Attached Files Attached Files

Posting Permissions

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