Dropdown list causes to show some comment from different sheet

Ch1253

New member
Joined
Sep 25, 2014
Messages
4
Reaction score
0
Points
0
[h=2]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[/h]
 

Attachments

  • Book1.xlsx
    24.6 KB · Views: 28

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
What information do you want to get from the sheets?
 

Ch1253

New member
Joined
Sep 25, 2014
Messages
4
Reaction score
0
Points
0
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
 

ags1980

New member
Joined
Sep 26, 2014
Messages
1
Reaction score
0
Points
0
please check the attached fill

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
 

Attachments

  • Book1.xlsx
    26 KB · Views: 13
Top