lists please help!
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 |
lists please help!
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 |
lists please help!
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 |
lists please help!
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 |
All times are GMT +1. The time now is 11:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com