software

Hello,

I was hoping someone could help me with regards to creating lists using
a different worksheet as a reference point

I'm trying to create a list in worksheet1 and use the data from
worksheet2. Can I also make worksheet2 quot;invisiblequot;(sorry for the
terminology) to other users.

Many many thanks for any input

Max--
Max_power
------------------------------------------------------------------------
Max_power's Profile: www.excelforum.com/member.php...oamp;userid=32255
View this thread: www.excelforum.com/showthread...hreadid=520963You could Protect amp; hide worksheet as follows
Select Tools gt; Protection amp; Protect worksheet with a password if desired.
Then Format gt; Sheet gt; Hide
Hope this helps

Jed
quot;Max_powerquot; gt; wrote
in message ...
gt;
gt; Hello,
gt;
gt; I was hoping someone could help me with regards to creating lists using
gt; a different worksheet as a reference point
gt;
gt; I'm trying to create a list in worksheet1 and use the data from
gt; worksheet2. Can I also make worksheet2 quot;invisiblequot;(sorry for the
gt; terminology) to other users.
gt;
gt; Many many thanks for any input
gt;
gt; Max
gt;
gt;
gt; --
gt; Max_power
gt; ------------------------------------------------------------------------
gt; Max_power's Profile:
www.excelforum.com/member.php...oamp;userid=32255
gt; View this thread: www.excelforum.com/showthread...hreadid=520963
gt;

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: www.excelforum.com/member.php...oamp;userid=32255
View this thread: www.excelforum.com/showthread...hreadid=520963Maybe you can use data|validation.

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

Max_power wrote:
gt;
gt; Thanks very much for your response, but can I create a list in
gt; worksheet1 from the data in worksheet2, I'm going to hide worksheet2
gt; but I want the data contained in worksheet2 to be a list in
gt; worksheet1.
gt; Can this be done?
gt;
gt; many thanks once again
gt;
gt; Max
gt;
gt; --
gt; Max_power
gt; ------------------------------------------------------------------------
gt; Max_power's Profile: www.excelforum.com/member.php...oamp;userid=32255
gt; View this thread: www.excelforum.com/showthread...hreadid=520963

--

Dave Peterson