Maybe you can use data|validation.

See Debra Dalgleish's site for some notes:
http://contextures.com/xlDataVal01.html

Max_power wrote:

Thanks very much for your response, but can I create a list in
worksheet1 from the data in worksheet2, I'm going to hide worksheet2
but I want the data contained in worksheet2 to be a list in
worksheet1.
Can this be done?

many thanks once again

Max

--
Max_power
------------------------------------------------------------------------
Max_power's Profile: http://www.excelforum.com/member.php...o&userid=32255
View this thread: http://www.excelforum.com/showthread...hreadid=520963

--

Dave Peterson