Use Drop Down list to display data

[zawwinmaung]

Hi, i have a problem with using drop down list to display data.

i created a list of name a,b,c
i created a drop down list so i can pull and select
a have a's contents
b have b's contents and c

once i select a
a contents will be display
and the rest too

the data in the a b c should be dynamic

is there any way to do that? with or without using VBA (i prefer without using VBA)

There will be total of four sheets
sheet1 - a's data
sheet2 - b's data
sheet3 - c's data
sheet4 - selecting form drop down list to display on sheet4 only (not on the other sheet1 or not using Sheet1.Select)

I will be thanking you!

 

[grizz]

it sounds like you want to hyperlink your drop down to the corresponding sheet is this accurate

 

[vds1]

Read Here, ,

http://office.microsoft.com/en-us/excel-help/create-or-remove-a-drop-down-list-HP005202215.aspx

http://office.microsoft.com/en-us/excel-help/insert-or-delete-a-drop-down-list-HP010072599.aspx

 

[zawwinmaung]

Hi everyone, this does not solve the problem

hyper link? it may possible but i am able to do it just select from drop down list then go to the sheet

however - i wish to display on the sheet4 itself four three data (a,b and c)

just choose a then display a data on sheet4
just choose b then display b data on sheet4
just choose c then display c data on sheet4

Thank you