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 "invisible"(sorry for the
terminology) to other users.

Many many thanks for any input

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

You could Protect & hide worksheet as follows
Select Tools Protection & Protect worksheet with a password if desired.
Then Format Sheet Hide
Hope this helps

Jed



"Max_power" wrote
in message ...

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 "invisible"(sorry for the
terminology) to other users.

Many many thanks for any input

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

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

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