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