Displaying information about a user selected cell

[kapilrakh]

Hi ,

I have a list of some entries.I want the user to select one of the entries and the excel file will display the information about it.

For.e.g. the list is

210-TT-45
210-TT-46
210-TT-47
210-TT-48
210-TT-49
210-TT-50

(The list is long so I don't want to use check boxes.)
.
All I need is a way to reference the cell (say A3 and A5) when user selects it.

Please reply.

[martindwilson]

create a drop down list using that data
then in the cell next to it use a lookup to retrieve data relevent to that.
can't help more unless you give an example sheet

[kapilrakh]

The data is already in drop down format.


Room No. Tag Name
1106 210-TT-045 X
1106 210-TT-046
1106 210-TT-047


Now, if user selects the tag name 210-TT-046, the relevant information (say Temparature) will appear in the next cell (marked as X, you can call it cell C2).

The information should stay there even if the user clicks any cell other than the one from column 'Tag Name'.

Please reply if you need more details cuz I need the solution.

Kapil.

[kapilrakh]

I am attaching a file here...It has the actual data....

Please look into sheet 2

[JBeaucaire]

Like this:

Please Login or Register  to view this content.