hi to all,

I want to create a drop down list and when i select a value from th
down list, it should take information from another sheet and display o
the drop down list sheet. For example, I have got 4 sheets--
consolidate sheet, jan sales, feb sales and mar sales.

I want a drop down list which allows me to select which sheet i want t
see.
(Excel 2000)

help is appreciated.

lail

--
Lail
-----------------------------------------------------------------------
Laila's Profile: http://www.excelforum.com/member.php...fo&userid=1580
View this thread: http://www.excelforum.com/showthread.php?threadid=27303

I've provided one response to your (later) post
in microsoft.public.excel
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----
"Laila" wrote in message
...

hi to all,

I want to create a drop down list and when i select a value from the
down list, it should take information from another sheet and display on
the drop down list sheet. For example, I have got 4 sheets---
consolidate sheet, jan sales, feb sales and mar sales.

I want a drop down list which allows me to select which sheet i want to
see.
(Excel 2000)

help is appreciated.

laila


--
Laila
------------------------------------------------------------------------
Laila's Profile:
http://www.excelforum.com/member.php...o&userid=15800
View this thread: http://www.excelforum.com/showthread...hreadid=273039